move excel files that have link between them
 

hi i have user that save a lot of files that modify or same data is used at
other file
how can i copy and change the index or the place that one files search the
other
for exp. the files where save at diffrent folders under my desktop
and now i move them to my folder on the network drive

--
yuval