merge different sheets into 1 sheet

[guptasweb]

How to merge all the different sheets into 1 sheet?

 

[awoohaw]

Do all columns have the same data?
You can use Power Query to do this in just few steps.
There are many youtube videos that can guide you through it:

 

[guptasweb]

Do all columns have the same data?
You can use Power Query to do this in just few steps.
There are many youtube videos that can guide you through it:

cant we use it vba code to merge data?

 

[Dan_W]

cant we use it vba code to merge data?

Yes. PowerQuery is probably the most straightforward method though. If you want, you can use VBA to control PowerQuery. But there are a lot of resources online that demonstrate how to merge multiple sheets into 1 with VBA.

 

[awoohaw]

cant we use it vba code to merge data?

You didn't answer my initial question. People need to know what the data structure before anything!