Just to confirm what you are trying to do (and of course you can do it with a macro). As a matter of interest is it a one-off thing or a regular event?

So you want to move columns of data (except for the header labels) into a different mapping of columns on another spreadsheet. Is the "new" in a new workbook (it might make life easier it was and this is a regular event)

regards