Copy data from specific sheets with matching column headers

[aamarb]

Hi Guys,

I have a spreadsheet that contains 30 sheets. I want to copy data form 5 of these sheets (sheet2, sheet4, sheet5, sheet6, sheet8 and they all contain named tables) to the master data sheet. All these sheet have the same column headers as the master data sheet, but are in a different order/column ref.

a sample of column headers are as below

Asset RAG Status

Asset Rag in Detail

Normalised location

Country

Many Thanks in advance.

 

[aamarb]

I forgot to add the table names are the same as the sheet names

 

[aamarb]

also posted on Copy data from specific sheets with matching column headers - OzGrid Free Excel/VBA Help Forum