Preserving links after relocating worksheet files
 

I have a number of Excel files that link to other spreadsheets. The files
are
located in a variety of folders.
Is there a way to relocate all files into the one folder and still maintain
all the links. I am hoping that by placing all files in one folder that
Excel
will look in that folder first to find any linked files. I don't want to
have
to open all files to get this to work or have to re-link to the new
locations.
I also want to be able to burn all related/linked spreadsheets to a CD so
they can be saved to another PC but still maintain the links.

regards
PeterH