Date range look up and copy/paste coding

You can save the file as a .xls and it will be a 2003 version, no adjustments needed. As a test (not in this uploaded file because it exceeded 9 MB in size), I also created 200 worksheets with each having between 20 and 1100 rows and then ran the macro on it and it ran quickly (less than 3 seconds) and properly. If you can upload a workbook that is having issues, I'll take a look at it to try to find where the problem is.