Selecting Multiple columns based on headers and copying to seaperate sheet

Guys,

I need a bit of help with this - I have a report that is run weekly and the information I need from it is under headings in Row 1, these are not always in the same column so I can't simply use column A etc.

There are approx 40 columns and I need to pull 16 of them out into a new worksheet in a specific order - for example Column Z might have header "Age" and I need that in Column A in the new worksheet.

I have been trying to approach this for an array perspective but it's not working at all for me so any advice would be greatly appreciated