Merge data from different sheets into one sheet

[excelkeechak]

i had different sheets containing the same type of data in every sheet.what i want is to merge all data into one sheet.i had attached the sample sheet for reference.also let me know how to know the last cell in the data sheet

[royUK]

The data looks identical on each sheet, is this just for the example. This will copy all data to the active sheet

Please Login or Register  to view this content.

[excelkeechak]

thanks for the reply. Yeah the data will be of the same length (I mean Columns - Headings are the same on each sheet).
by the way.how to renumber the col S.No after copying the data to the active sheet. After running the code , the data got copied into the active sheet.but i think if i add a new sheet and update all the data there into the new sheet and renumber the rows starting from 1. how to do this.???

[royUK]

Try this

Please Login or Register  to view this content.