Hyperlinks - change sheet but not cell reference for multiple hyperlinks at once

Thanks for getting back so quickly.

I've uploaded an example spreadsheet. I'll try to explain...

The sheet 'CB1 Index' has hyperlinks set up to the relevant tables on the 'CB1' sheet.

I want to be able to update the hyperlinks on 'CB3 Index' to correspond with the 'CB3' sheet, but they have been copied from 'CB1 Index' so currently link back to the 'CB1' sheet.

Is there a way to update the sheet reference, but keep the cell reference the same (as this will not change)? Obviously in this example it wouldn't take so long, but the document I'm working in has a much longer list and there are multiple sheets.

Thanks in advance!

Matt