Hi

I'm importing data on a weekly basis, and publish a report with historic data over four weeks. Every week new data are importet to the 'ThisWeek' page, and last weeks data are moved to 'LastWeek' -> 'TwoWeeks' -> 'ThreeWeeks'. After four weeks, the oldest data is moved from 'ThreeWeeks' to a newly created page named with the import date ('yyyy.mm.dd').

All pages are identical in layout. The Pivot gets the same column (500rows) from all four pages and name the chart from "O2" / import date.
My Pivot is re-populated with the folowing sckript

Please Login or Register  to view this content.
I really would like to get the above code to collect data from pages I define in a predefined cell in order to be able to compare data from various weeks, not only the last four. I have data from the last year in different sheets ('yyyy.mm.dd').

I'd like to be able to write the name of any sheet and have the code get the arraycode from these cells
A1:Get data from - B1:'ThisWeek' - B2:'TwoWeeks' - B3:'2012.05.01' - B4:'2012.01.01'

How can I re-write my code to do this?