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!