Macro to copy data from multiple worksheets into 1 worksheet

[madhaviblr5]

I've multiple worksheets but I need consolidate from five ("India", "Japan", "china", "australia" and "south korea") worksheet to "Master" worksheet

Problem is Headers in all the sheets are difference hence I need to copy and paste the details matching the header in Master worksheet.

If I get the Tab name in column A would be the great Help.

Please help me.

 

[cooper645]

you say the headers are all different, are they completely different as in text, or just a different order?

I would say that vba would be an ideal solution, but the solution will be dependant on your tab/column layouts.