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...