Need Help summarising excel data

[Himanshu112]

Hi everyone,
I have 4 sheets in a workbook i.e sheets a,b,c,d I want to summarise all data in a summary sheet, but the thing is when sheets a,b,c,d get updated summary sheet should be automatically updated with the new data and I am using excel 2016 so can't use filter and vstack formula.
I really appreciate any help you can provide.

 

[AlanSidman]

With Power Query, this can easily be achieved. In a new file, Data, Get Data, From File, From Workbook. Then Append then to a new Query. When new data is added or worksheets, PQ will auto update when Refresh All Icon is selected.

Here is a tutorial

 

[mohamed ilyas]

hi
convert to all table and user power query to append all table in one.. whenever update other sheets, just refresh main summary sheet.

 

[Himanshu112]

Many thanks for this but is there any way to get this done without using power query?

 

[Belleke]

What about this?

 

[Himanshu112]

What about this?

Thank you very much

 

[Belleke]

Glad to help.