Pie charts with data from multiple worksheets in one workbook
 

I am trying to create pie charts from data that is on approximately 15
different worksheets within one workbook. Basically each worksheet is a
summary of payments received by quarter, by company. I need to capture the
payments from each company for five years then chart it. I am trying to
avoid summarizing the data on a different, separate sheet in order to do
this.

Any ideas, hints, etc. would be appreciated!