VBA open another Workbook copy and paste if condition is met

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:
Attachment 25122

This is the destination of Master workbook (date is entire year):
Attachment 25123
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:
Attachment 25124


Thanks in advance!