Modify Existing VBA Code

Hi Guys

Looking for your help as I'm struggling to modify the code I'm currently using. Currently we get a report generated on a daily basis this Report is then used to populate a separate spreadsheet which is then used as a working Spreadsheet. We use the SFDC Contact ID as a unique Identifier. What I am looking to do is that if new data appears in the daily report for an existing record on the MainSheet then the new data from the report is added to the existing record.

I have attached an example with an initial report and then a sheet called Updated Report which has additional information that needs to be pulled into the Main Sheet.

Any help would be greatly appreciated, if anyone can see a better way of doing things I'd love to know!

Thanks

Jay