Some help with excel consolidation!?

I've got two different spreadsheets with similar data. unfortunately this is confidential information and company work so I cannot share the sheets. But essentially I have two different excel sheets, each with information on different hospital networks (name, location, number of hospitals in the network, etc.) but they are from different sources and thus each sheet has some blanks that the other has filled, and some have conflicting pieces of data. I've tried the normal consolidate rules, have all of the columns listed the same, but in the end one just completely overwrites the other. I'd like for blanks to be filled automatically, and for discrepancies to be asked one by one which i'd like to choose. is this possible? thank you