Combining Spreadsheets, then Pivot

[AccessPower]

Hello All,



I am not super experienced with excel, so I have a question about combining worksheets.

I would like to create a worksheet that combines the data in other worksheets, and then have a pivot table pull certain fields from the combined sheet, so something like the following setup:

Pivot
^
Combined
^Sheet1
^Sheet2
^Sheet3

The sheet1-3 will be updated fairly regularly, so how do I go about adding them to the combined sheet and be able to have the range automatically update (or set the range to max of the other sheets and use criteria that only pulls if the rows contain data.)

Thanks!

[vnpatel]

Hi,

You can combine worksheets by doing following steps.
1--Start the Consolidate Worksheets Wizard. ...
2--Select worksheets and ranges to merge. ...
3--Select the consolidation type. ...
4--Choose how you want to merge sheets. ...
5--Select the destination for the merged data.