Subtotals to separate sheets?
 

I have a report I create weekly that is about 50,000 lines. It is requested
that they be subtotalled by one of the columns (making about 30 subtotals).
I then have to make a separate sheet for each of these 30 subtotals within
the workbook and paste the contents of each subtotal in each sheet(still
leaving the master totals page). I have to create one of these for 03 04 05
and 06 each week so I need to know if there is a way to subtotal to separate
sheets because copying and pasting is where all my time is spent. Thanks!
Eric