Hi.

I have been tasked preparing a graphic model which extracts data from over 100 weekly spreadsheets in a workbook. I have formatted the layout so that the data is laid out in a template form. The problem i have is how to efficiently extract and present this data with a program that will jump from sheet to sheet automatically. I have considered using PivotCharts without much success. Any ideas would be welcome. Thanks, Russ