I have 20 separate spreadsheets that are emailed to me monthly with updated
information. Every month I need to sum the data (example: add the B10s in
all of the spreadsheets). I've created a master spreadsheet linked to each
of the 20 spreadsheets, but I've found I need to recreate the links every
month. If I try resaving the new updated file over the top of last month's
spreadsheet in hopes that the link will still work, I get a #REF on the
master spreadsheet. Is there any way to create a master file with links that
will update without cutting and pasting from the 20 new files to to 20 old
files?