I don't think there is a practical way to do that. You can get create
dynamic paths with INDIRECT functions, but you'd have to put that in
every formula that links to the other file. And, INDIRECT does not
calculate unless the other file is actually open. And, I think it
would be just as hard to set up and maintain, anyway.

One way to avoid manually changing is to use Replace to change every
single formula at once. This should be about as fast as using the
Links:Change Source commands. But you would need to make sure the path
is perfect to replace it. Copy/Paste would be useful, you can Paste
into the Replace window. Also, don't have the source file open when
you do this because Excel will hide the full path if it is open. And
you need to work on the full path.