Pivot table from multiple worksheets . . . possible?

[Guest]

Is it possible for a pivot table to pull from multiple worksheets, provided
the information being pulled has the same number of columns with the same
format?

Thanks for any help!

 

[Debra Dalgleish]

If you create a Pivot Table from multiple consolidation ranges, you
won't get the same pivot table layout that you'd get from a single
range. There's an example here:

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

If possible, store your data in a single worksheet, and you'll have more
flexibility in creating the pivot table.