Updating Links on Excel

Giganews Newsgroups
Subject: Updating Links on Excel
Posted by:  Update Link Question
Date: Mon, 22 May 2006

I have a spreadsheet that summarizes data from 300+ different workbooks.
Every month a new file is created and we need to update the summary with the
new month data.  Is there a better way to update the links on the summarizing
spreadsheet?  Currently, we need to edit links and update links for each
(300+) file name.  The only thing that changes in the file names is the month.