You can create a pivot table from the 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

naseri wrote:
hi Dear friend
I want to make a single pivot table from all my worksheets in a single file
in excel 2003. thanks.


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