Extracting data from multiple (>100) sheets in a single workbook for graphic presenta

[Russ007]

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

[davesexcel]

Here is a site that you may find useful,
http://exceltips.vitalnews.com/Pages...owerPoint.html
You may have to get more info from the author
http://exceltips.vitalnews.com/questions.html