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.