Consolidation Table from Different Excel Tabs with Different Format

[alisher_n]

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 code, WBS description, source type, location, source description, quantity, total price. 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 readily available in a tab without running macros. But if there is no other options, then VBA is the way.

Thank you in advance,
A.

 

[alisher_n]

Here is the link to the OneDrive, filename is Sample.

In this sample I am using 4 source tables.

OneDrive

1drv.ms

Thanks.