I am sure that you understand what you are explaining but I honestly do not understand which date (based on which column) you want to make the selection.
If you say both worksheets, does this mean only the rows of data within the date range that exist in both worksheets?

What I need to know is clear and simple: WHAT DATE (column) DO YOU WANT ME TO FILTER ON?