I want to create a pivot graph in Excel 2010.
The graph needs to pull data from 4 tabs that are updated weekly. All of those tabs contain the same data, but not displayed in the same order.
My solution was to create a 5th tab that populates itself with data from the 4 others. All I really need is data from 10 columns. I was thinking of using a VLOOKUP, but since the columns are not in the same sequence,not filtered, and modified each week, I don't think it's an option.
I'm including a dummy file to play around with, as the real one contains sensible data.