Depends upon how you data is laid out on each sheet.

If your total in each sheet is same cell you can use

=AVERAGE(Sheet1:Sheet6!A1:A10)


Gord Dibben MS Excel MVP

On Mon, 28 Sep 2009 07:39:01 -0700, CWhite1972
wrote:

I have a workbook that contains multiple worksheets that I need to "average"
the results in a new worksheet within the same workbook like a summary page.
For example, I have customer surveys from multiple clients that I enter
separately into one worksheet. My goal is to then gather all this information
into one summarized spreadsheet at the beginning of the workbook. How is this
accomplished? I'm not too familiar with the how-to's of doing this at all. I
an using Excel 2007.

Thanks.