Bulk link updates

First off, apologies if this is in the wrong community.

All files are held in the same sharepoint library.

So in the library there is an excel file which gets updated a couple of times a year and lets say 20 word fiiles containing roughly 5 links per file referencing 4 ranges in the excel file. These word documents are also updated several times a year.

When either the excel documented if updated a new file if generated with a new name which replaces the old one and the old one is archived.

The word documents are simply edited and renamed with the old one being archived.

I'm looking for a way to update the links in the word documents to pick up the same ranges in the new spreadsheet. As it currently stands I need to manually update each link which is time consuming, prone to error and stupid :-)

anyone come across this need and if so how did you solve it?

thanks in advance