Find latest date when the name appeared either formula or vba multiple sheets

[KK1234]

Hi,

I have 3 sheets in a work book.
In column A, I enter the date in each sheet
In Column G, I enter the name in each sheet

I want to populate in 3rd sheet with latest date when the name had appeared.
It is very tiring to type Lookup or Vlookup in each cell .( actual workbook there is too much of a data)
Is there any easy way of doing it please?
I have attached sample workbook
Many thanks
Kind regards

[JieJenn]

Easy if you add help columns.

[KK1234]

Hi JieJenn,
You are very right. never thought of this before.
Thanks very much for such a prompt reply and help.
You made my day
I have clicked * to express my gratitude.
I am closing this one as solved.
Again thanks a lot
Kind Regards

[FDibbins]

Try this in B2, copied down...
=MAX(INDEX(Sheet2!A:A,MATCH(Sheet3!A2,Sheet2!G:G,0)),INDEX(Sheet1!A:A,MATCH(Sheet3!A2,Sheet1!G:G,0)))

[KK1234]

Hi FDibbins,
This works like a magic and more easy one.
Thanks for your kind help.
You too have made my day
I have clicked * to express my gratitude.
Thanks again
Kind regards

[FDibbins]

Happy to help and thanks for the feedback