combining tables from different sheet in the same workbook / file

[nsimha]

Hi,

I have a excel sheet containing about 10 worksheets. All the worksheet contain data with similar column headings..

Formatting data from these 10 sheets as tables, I am able to use msquery - union all and create a mastersheet combining all the data in a new excel workbook and generate a pivot report.. This also gets refreshed whenever the original data changes.

Unfortunately I am not able to figure out on how to get this done in the same workbook..

Any suggestion (using msquery) would be of great help