VBA to Copy data on date

Hello,

Team please help me with the below situation.

I have 15 workbooks, every day i capture data in sheet1, it has 8 columns, with date in 7th column which i update as work date the day i work.

i tried recording macro but data is overlapping. i would like a msg box popups while running the code that asks for date, or date range. once i feed required dates for which i want data , the code copies all the columns and rows from all the workbooks with that date or date range and paste in new work book. Date format is mm/dd/yyyy.

Any help will be much appreciated.

Regards,
technogene007