Excel 2003 - BUT I do have access to the latest Office, if there are
tools there that will do the job

At present I have two Excel files A & B
B has about 15 sheets with data and A has about 10 sheets with data
Some of the ranges or cells in A are linked to cells in the sheets of B,
to get their data.
I want to merge the two files into one, to make life easier.
How can I do it to:
- retain formatting in all of the sheets
- and to retain the links from the sheets in A to their locations in B

Thanks
Doug