macro to select the most recent date

[harshab6]

I need a macro which could compare the dates between 2 sheets (which contains date in column A and other data like product, customer name etc. ranging from column B:F) I.e sheet 1 and sheet 2 and filter the most recent dates in sheet 1 which are not available in sheet 2 and copy the data from sheet 1 which is in ranging from B:F to sheet 2 I know I can use Vlookup but vlookup doesn’t work if there are multiple lines with same date but with different data ranging from B:F


Thanks for help,
Harsha