Merging multiple workbooks with crosslinked formulas into single f
 

I've been using a set of 6 workbooks for various inventory tracking tasks,
with multiple worksheets in each workbook, and all using formulas that link
to data in other workbooks and/or worksheets. I've found various solutions
for merging basic workbooks into a single workbook, but nothing that seems to
fit my particular setup - I'm about to upgrade to Office 2007, and want to
consolidate these workbooks into a single file, eliminating the extra files,
while maintaining the formula links to the proper data in the new file - the
merge solutions I've found and tried that keep the formula references keep
the fomulas linked to the old files, rather than updating the reference link
to pull the data from where the data was placed in the new file. I know this
probably sounds a bit confusing, but would appreciate any suggestions on how
to go about doing this, as it would save a ton of time vs having to manually
go through the files to rebuild them as one. The files had to be split
originally for ease of flash drive transport and use by multiple personnel,
but now that I've got central network storage at work, its an unnecessary
complication, and merging the files would make it far easier to pass
inventory control on to somebody else...