How merge all sheets into one sheets

[baskar5353]

hi,

I'm having 5 sheets. i want merge all sheets into one sheets in same workbook how to do in VBA.

 

[My Aswer Is This]

We would need details.
Are all sheets laid out the same?
For example all columns are the same?
How many columns are in each sheet?
So are we going to take all the data from sheet 2 and put it into the same columns in sheet 1 after the last row in column 1 or how are we going to do this?

 

[baskar5353]

in all sheets columns are same there are 114 header is there.

but i need only 7 columns only