Consolidate data from multiple sheet to one sheet

[kesavanprabhu]

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…