+11 Create Pivot Table From Multiple Worksheets Excel 2010 References. This will enable the pivot table wizard, as shown below. Create a pivot table from multiple worksheets of workbook you create an excel pivottable based on multiple worksheets you advanced pivottables combining data from multiple sheets 134.
Now, select the third option that reads as multiple consolidation ranges. Excel a pivot table with data from a pivot table. For example, if you have a pivottable of.