I have a file (a) that has links to another file (b) which is in a
defined format.

Each month this file (b) is updated and renamed file (c) and it is now
this most current version of the file that file (a) needs to link to

Is there a macro that can be run to update link names?

I am quite a novice so would appreciate the code.