Pulling out the latest records ONLY. VBA

Hi there,

I have attached the file.

What I would like to do:

For each record in column A of "test" worksheet, I want to keep the the ones with the latest date. So in "output" worksheet, you will see ONLY those records with the latest date.

Sometimes, there can be up to 3 or 4 lines for the same record, with each line showing different dates, but I only want the latest date, which is the last one for the record.

Can this be done using a macro of some sort?

Guidance or comment is much appreciated.

Thanks