A file has no way of being referenced except by its name, so if you
change the name of a file the only way it will be automatically updated
on opening your workbook would be if the list was re-created.

If the files in your list are, for example, all the Excel files within
some directory structure, arranged in order of the date of last
modification, then a macro run on start-up could generate the list, and
the list could either be straight text or hyperlinks.

So, if you would like to give details of how you select the filenames
that go in your list, how you want them displayed, whether there is any
related information alongside each name, how you sequence the filenames
in the list etc. we could confirm whether automatic updating was
possible and give some ideas on how to do it.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup