I'm trying to create a macro
OK, so you are trying to create a macro, and you have told us what you want it to do.
What help are you asking for -
Do you want someone to write this macro for you, or do you want some suggestions as to how this macro could be structured to meet your objectives.
If you are trying to create a macro, have you written any code yet - if so, you could post it and identify what isn't working and ask for some help.
If you want someone to write it for you, that's a pretty big 'want' - Everyone who answers these posts is volunteering their time and knowledge and this is not a 5 minute task.
... you have not identified what happens if this macro is re-run. What happens to data already copied - is it erased first and all the new data moved to its destination.
What happens when a different date range is selected - are the rows copied to the destination worksheets below the previous data.
Is data moved to new workbooks for new date ranges.
Are checks needed on the input dates to test for acceptable date ranges.
If anyone does write some code for this - are your workbooks really named "Workbook1" and "Workbook2" and what are the file extensions. Will the two workbooks be open before the macro is run, or will 'Workbook2'.xls' need to be opened.