Macro code to pull data from different sheets based on the header of the main sheet

Hi,


I need a macro to pull the data from different sheets (the columns are not properly alligned) to one single sheet based on the header of the main sheet. but some sheet will have the data in middle of the sheets.

Please find the below data sheets (it has 3 sheets (Main sheet and 2 sample data sheets).


Thanks,
Uday kumar