Can Pivot tabel be linked to multi-tabs?

[yhoy]

Due to capacity constraint, data are cut into multi-tabs. How to create Pivot
out of all of them, if possible?

Thanks!

 

[Debra Dalgleish]

You can create a pivot table from multiple consolidation ranges, but the
results may not be exactly what you want. There's more information here:

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

Perhaps you could store the data in a database instead, and base the
pivot table on that.