merge excel columns from different worksheets to new sheet

Using Excel 2003, I have a workbook with 7 worksheets each containing 160 rows plus a header, each worksheet has a key field (employee number) and several unique columns. Looking for an easy to understand solution to merge the columns from all the worksheets into a new sheet - once data is merged, the key field is only required in column A.

When the data is first exported from our in-house custom app it has an initial 13 rows of information which is normally deleted manually - if there is an easy way to add part of the script to remove the first 13 lines of each worksheet prior to the merge it would be a bonus (the header line is initially on row 14 prior to me deleting the other info).

I've found scripts which will merge rows but not columns - any assistance would be great.

Thank you.

Jason

Sorry for the delay - work has been quite busy this week.

I've uploaded two files - one which details the manual process which is currently used to clean up the data prior to being imported to MS Access 2003 and the second is a sample of the Excel data.

Please advise if additional details will help understand the final goal.

Thank you,

Jason