Pivot Tables & Multiple Worksheets

Background: I know ZERO about VBA and I am a Vlookup & Pivot Table noob, but experimenting everyday.

Here is what I have been struggling with:

Every week, since August 29, 2009, I get a sales report from my customer in raw form showing point of sales data for the previous 7 days. After manipulating the data I end up with 11 columns.

Now, if I am only concerned with that one week then I can drop the whole sheet into a Pivot Table and all is well.

However, I have 12 sheets now (with more to come), one for each week, and the row count ranges from 3,328 to 16,414.

I do not want to consolidate the data.

I can copy everything to one sheet, and hope not to max out at the million row mark, but would prefer to keep it tabbed by week.

I can provide the data but would prefer not do so on the forum.

Thanks in advance!