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?

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


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Petersjill" wrote in message ...
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?