Consolidated Table from Different Excel Tabs with Different Table Setups

[alishern]

Hi all!

I have 5 (source) tabs with tables with data but in different formats. They all have common data but column headers are named differently. I want to have a separate tab (consolidation) that consolidates all but certain columns only:

WBS

WBS DESCRIPTION

Resource Type

Location

Resource Description

Total Qty

UOM

Unit Rate

Extended Cost

I want the consolidation table to be updated instantly with every single update that happens to each of the 5 tables.

My preference is to have it formula driven as i want to have the table readily available in a tab without running a macro. But if there are no other options, then VBA is the way.

Please see image below. In the image I have posted 4 sources. Consolidation table has all 4 of them consolidated. Please note that the consolidation table should only pick data from the yellow columns.

Thank you in advance,
A.

 

[alishern]

Here is the link to onedrive with the sample file.

Microsoft OneDrive

1drv.ms