Merging worksheets & consolidating the date

[SilverFoxx79]

Hello

I'm a bit of a noob and need some help!

I have 2 property spreadsheets to combine, the both have roughly the same data but both have some missing compared to each other and most data has been changed/updated. So I wish to combine and update both into a master spreadsheet without creating duplication of those rows/fields/cells which have not changed.

So far I have only been able to merge the spreadsheets with duplication of the rows, there is to much data to filter manually. I've been trying to work out a formula to combine both sheets based upon the only constant cells throughout both sheets which is the data held in column C (Code) which is unique to each building. The building names have been changed and the owners are constantly changing.

Here's an example

[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]Community[/TD]
[TD]Building Name[/TD]
[TD]Code[/TD]
[TD]Unit[/TD]
[TD]Name[/TD]
[/TR]
[TR]
[TD]Uptown 1[/TD]
[TD]Block A[/TD]
[TD]1[/TD]
[TD]201[/TD]
[TD]Smith[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]A Block[/TD]
[TD]1[/TD]
[TD]301[/TD]
[TD]Jones[/TD]
[/TR]
[TR]
[TD]Uptown 3[/TD]
[TD]A Block[/TD]
[TD]1[/TD]
[TD]302[/TD]
[TD]Smith[/TD]
[/TR]
</tbody>[/TABLE]


I'd greatly appreciate any advice you could give me.