Hello. Hoping someone might be able to help and potentially save me lots of time!

I have a document that has 8 sheets, 4 with different data tables in them and 4 contents pages. I've set up hyperlinks on one contents sheet to take people to the relevant tables.

The other three contents sheets need to include exactly the same cell references but the sheet number needs to be changed (the tables are the same size doing down the rows, but are different across the columns).

I've tried selecting all the relevant cells and changing the hyperlinks together but this doesn't work. I've tried setting up a macro (unsuccessfully).

Does anyone have any idea whether this can be done, other than editing each hyperlink individually to select a different sheet? That would take a VERY long time.

Hope I've explained that clearly. Thanks in advance!

Matt