Consolidate data from multiple sheet to one sheet

Hello,

I have attached sample spreadsheet, In the spreadsheet you can find multiple sheets, I need to consolidate all the data in final sheet.

Eg: Sheet1 to sheet5 please do not consider, From sheet KY9374 to sheet KZ1768 we need to consolidate in final sheet.

Header details are common in all the sheets, we need to copy data from sheet KY9374 with header, then sheet KU7991 data without header, then KW8660 data without header etc.,

Here if you see in sheet KY9374 we have only one line item so we can copy that one line item and paste in final sheet and then it should go to sheet KU7991 and it should copy the details(excluding header), here we have eight line items( you can see that in x column) so it should copy the 8 line item and paste in final sheet from 3nd (A3)row.

then it should go to sheet KW8660 and it should copy the details(excluding header), here we have 22 line items, it should copy all the data and it should paste in 11th (A11) row of final sheet

Similarly it should copy all the data from all sheets and paste in final sheet,

Finally the worksheet should carry sheet1 to sheet5 and final sheet the other sheets can be deleted or it can be hidden.

For this I need a macro please help me…

Hi Jerry,

I am new to macro coding and i find very difficult to execute the below code, when I execute the below code only 1st line item of each sheets are pulled in final sheet but my requirement was different if you read my post # 1 fully u can understand my exact requirement, please help me on this..

Please Login or Register  to view this content.

I'm also having the same problem but I need to merge specific sheets and not all the sheets in my workbook

boom,
Please start your own thread!
Attach a sample and I will help you.