Pie Chart & Graph - dynamic data source

[Charmwah]

Hi all

I have a workbook, with a worksheet for each month which contains a table in which daily figures are input. Next to this, I have another worksheet with reports of various pie charts and graphs to illustrate where the work time has been spent, enquiry origin etc etc. which are created from the monthly worksheet.

I am now debating whether I need a worksheet of reports for each month, or whether I can simply use a single worksheet and choose (from a drop down?) the month I wish to see the reports from? The only thing that will change in regard to the data source(s) is the name of the worksheet the data comes from, the actual range within the worksheet will remain the same. For example, January's data will be in 'Jan 17'! A1:D100, February's will be 'Feb17'!A1:D100...

Thanks in advance!

 

[mart37]

Everything in ONE table (on one sheet).
With PIVOTTABLES can you make your summaries.

 

[Charmwah]

Everything in ONE table (on one sheet).
With PIVOTTABLES can you make your summaries.

Thanks mart37. But this then presents the problem of populating a single worksheet with all of the information. How best to approach this?

I'm happy to look at restructuring the entire workbook, but it does consist of separate worksheets with pivot tables, seperate worksheets with background information with customer details etc.