You could record a macro while you do the copy/paste a few times, and
then if you examine the code you will be able to see the similarities
and differences. If you did it five times, say, then you will notice 5
different dates specified as filter criteria, so this might help you
to see how you could edit the recorded macro by, for example, taking a
date from a cell somewhere and then repeating the filtering for 5
consecutive days (or 10, or some other multiple).

If you expect to generate 9 different worksheets from 2 years' worth
of data, then I suppose you are splitting it into quarters (90 days?).
You could create the blank sheets yourself and then edit the code to
do 90 days into one sheet, and then just edit the sheet name for the
next 90 days.

It depends how proficient you are with VBA, but I think a macro is the
only way to achieve what you want given the number of days that you
have.

Hope this helps.

Pete