Consolidate Woorksheets
 

Hello-

I'm having a problem consolidating several worksheets.
I've looked in Excel help, but when I get to the Consolidate Window, I have
a limited amount of functions to choose from - none of the say "position" or
"category" or "3-D". Am I in the wrong place?

The only functions I have a sum, count, average ... varp

I was given a workbook that had 5 worksheets with different salespersons info.
I think I would like to consolidate the data and then use pivot tables.

Thank you in advance.