Consolidating databases excel
Fortunately, Microsoft Query is an alternative that is available in all versions of Excel that can guide you through the process.
The process I’ll describe can work within an existing workbook, or you can pull data from multiple workbooks.
For example, if your sheet names are "East" and "West", change this line of code: In the code, you can also change the location where the pivot table will be added.
In the sample file, the Table Destination is set for the active sheet, in range A1.
To see an example, download the Union Query sample files.
It has a query that was built manually, and has a button to refresh the data.
However, it's a bit tedious to set up, especially if you have more than a couple of tables.
The zipped folder that contains the file, and the five sample data files.