Update hyperlink buttons automatically when files are copied (Exce

[JayWes]

I have multiple Excel files linked together using macros buttons. I would
like the file extensions to update automatically when the files are copied to
a new directory the way the built-in hyperlinks do. Help Please!