Create consolidated dynamic sheet from several sheets (pull data)

Hi,

Recently, I work on the budget file, which will include many sheets, but in order to create a pivot table I would like to Consolidate or merge these several Sheets into one sheet as creating Pivot table from several sheets is not flexible in tmers of filtering and so on.

table sin different sheetsdiffer from each other with their columns numbers, but first four columns are identical and the columns containing numbers are also idnetical.


I could copy al these data into one sheet but there are dozens of sheets, also sometimes data must be changed in one sheet, so that I will have to go through consodilated sheet and each time change the value.


Please advice, if there is any tool, function or even VBA code to automate these process, make Consolidated sheet dynamic so that changes in sheets could be reflected in Consolidated sheet. or any soluton which will not rquire the Copy-Pasting.


In order to clarify my problem, I amuplaoding the sample file...


Thanks all in advance.

FILE: Book1.xlsx

Try the attached

The attached file contains the SUM sheet which indicates the columns to be copied, please, if you can provide with the code.

Lots of thanks, the great code, works as it was expected, I will restructure some code to fit my sheets, thanks, I have no words, how to thank you.... thanks thanks thanksssss