Ideas on how to track weekly trends from multiple files

Hi oeldere,

Thank you for your work. I had to do make some modifications to your pivot table/chart to fit what I'm looking for and created another pivot chart to give me a better sense of what I'm looking at (see attached spreadsheet). Overall, this was a great solution to what I'm looking to do.

Just a quick question...on your "Consolidated" tab, did you use a formula to get the data from the various tabs or just copy/paste the data directly into the list on the "Consolidated" tab?

Thank you for your help.