Combined all data from 4 sheets to another sheet as consolidated

Here is how to do it with PowerQuery: https://www.youtube.com/watch?v=YOC-pEIuHpA

Thanks AliGW for your reply, you have a way to learn it. But i am not good in excel. could you or any one else can give me a VBA. thanks.

Actually it is not an amount or numbers to combined..

I want all text or numbers same format from all sheets to be copied and paste in sheet "ALL"

Thanks

As Ali indicated earlier. Power Query is the way to go. Here is a file with all your data and the Mcode that did that.

Please Login or Register  to view this content.

Review PQ
In the attached file
Click on any cell in the new table
On the Data Tab, click on Queries & Connections
In the right window, double click to open Query
Review PQ steps

M-code basics:
- "let" is the start of a query
- "in" is the closing of a query
- each transformation step sits in between those 2 lines
- each step line is ended by a comma, except the last one
- "Source" is always the first step (Source Data)
- After "in" you have the last step referenced

dear alan,

its looks worked, but since i dont have any idea how to run it or how to use mcode.. for me its a simple sheet only. dont know what to do and how to run it again. kindly help to explain

also below error is giving on opening

An error occurred in the ‘aicg’ query. DataSource.Error: Could not find a part of the path 'C:\Users\alans\Downloads\sample file for copy sheets data.xlsx'.
Details:
C:\Users\alans\Downloads\sample file for copy sheets data.xlsx

You need to change the path to where your file is located. The error you are seeing is because you don't have access to my computer where the file was located when I retrieved the data to bring into Power Query. I used the same technique described in the video Ali presented to you. Follow it using your data file and it should result in the same output. All I did was bring each sheet into PQ and then append each to the other.