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

Perhaps you could store all your data on one sheet, or in a database,
and create the pivot table from that.

Malik wrote:
hi, how can i build a pivot for data in two or more sheets in the same
workbook?
if i cant make a pivot, what are the possible alternatives to consolidate
the data.

thanks in advance.


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