Macro code to pull the data from different sheets to main sheet

Hi,


I need a Macro which pulls the data from different sheets of excel (which is not formatted properly) to Main Sheet. Also some of the columns will not have the same names (customer will give different names for the columns some time), so macro should handle this exception as well.

Am attaching the excel which has sample 2 types of sample data and also attaching the excel which has the list of different names which customers will update while providing the data.

Any help would really appriciated.

I wanted to pull the data based on the column name mentioned in the main sheet. and mapping sheet has the different names that custome can give (heading the original name in main sheet and the list under the headings are the different names customer can give).