I need to delete duplicates with older information in

Hi guys,

I hope someone can help me.
Been trawling through the forum but cant seem to find exactly what i'm looking for.

Basically i have 2 spreadsheets i am merging.
One (S1) is the main spreadsheet with details of Wills and the client who it belongs to and is updated daily.
The other (S2) is a smaller speadsheet which is just concentrated on finding wills and info that was not initially found.
The second spreadsheet is more up to date in relation to our 'missing' Wills and so have more info in my 'comments' column but the rest of the row info is the same.

When i merge the two (same column format etc) is there a way that i can delete the duplicates with older info (in S1) or replace that info with that from the newer spreadsheet (from S2)?
Or even just merge both sets of information?

Im not great on excel so a dummy's guide to this problem would be fantastic!!

it will be a great help, if you can provide a sample file for refrence,,,,
and do you need a VBA code or just way you can do it manually?

example.xlsx

I really am pretty novice at excel but slightly know how to write formulas and work my way round excel
but as simply a way to do this as possible would be great.

The only column that will be different will be the comments back. it will have more updated info so i need to keep this

ideally - working around the will no. column or name column would be best.

and sorry please find updated version of my example showing duplicates

example.xlsx