Hello all,

I am very new to Excel VBA and currently working on a project, one of my task is to download several reports (Excel workbook) and copy paste into Master workbook. I am thinking maybe I can make this job more efficient by using VBA.

This is the report to import, the first row's date will be today's date:

This is the destination of Master workbook (date is entire year):
Is there any way to import data when the date is match so I can keep history data?
Right now my Vba code look like this:

Thanks in advance!