You can create a pivot table from data on separate sheets multiple
consolidation ranges), but the results may not be exactly what you want.
There's more information he

http://www.contextures.com/xlPivot08.html

Todd wrote:
I have a workbook with 9 worksheets that I need to pull together for a
report. Can I use a pivot table for this? It would need to pull from all
those sheets and I don't know what the limits are.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html