I have temporary file names that I need to enter into Excel, but I know later
on they will change. Is there any way to automate this so that when the files
are renamed the spreadsheet will automatically update?

This would be very helpful.
Thanks,