Merge data under same column heading from each sheet

[kets0985]

Dear Expert,

I need a code which will search the column heading in each sheet and collate the data below that heading to the main sheet.
Please find attached the excel sheet for reference.

The sheet "Collated Data" consist the column headings under which the data needs to be collated from each sheet. In some sheet the data is in 3 rows and in some sheet it is in 2 rows.

I need to searach the column heading in each sheet and when the heading exist in that sheet the data below that should be copied and pasted in the sheet "collated data" in one after another row.

Please let me know your views.

Regards,
KB

[jaslake]

Hi KB

I have no clue if I understand your issue. This Code in the attached creates my perception of your issue...CTRL + q will fire the Code

Please Login or Register  to view this content.

[kets0985]

Yes this works perfectly..

Thank you very much.

Your help is really appreciated.

Regards,
KB

[jaslake]

You're welcome...glad I could help.

If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.