I have a multi-tab spreadsheet with simple links referencing different cells.

The problem I am having is that it the spreadsheet goes through a report generator and it changes the tab names, creating broken links.

Any ideas in solving this problem?