Creating a dynamic Pivot Graph, data pulled from severa tabs, updated weekly

**nickstoy** · 06-20-2012, 10:55 AM

Greetings all, this is my first post

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.

dummy file - PGE Project.xlsx
Thanks

**nickstoy** · 06-21-2012, 10:08 AM

I found a quick fixbut quite honestly it sucks. I now have 900 000 lines in a tab, and I have terrible lag and performance issues.
Anyone's input is welcome