update linked spreadsheets w/o recreating links

[Guest]

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?

 

[Ron de Bruin]

Hi Petersjill

Maybe you can use this every month
http://www.rondebruin.nl/summary2.htm

To get the workbooks from your mail folder try
http://www.rondebruin.nl/mail/folder2/saveatt.htm