Hi Community,

I am desperate to get some help. I'm not an Excel fundi and have a serious issue. I created a sheet "Sheet1" and filled it with content. There are 100's of hyperlinks to the same sheet used for navigation. I have .png arrow all over the sheet to move to different places in the sheet, e.g. "Back to Top" etc. I did not know this would happen and there are a lot of links. I need to duplicate the page 12 times. It will take days to redo every for all 12 months of the year. I really need an easier way than manually changing every single image based hyperlink.

Practically, I need a way to rename "Sheet1" to "January" and copy it to the same workbook for "February", "March" etc. - The issue is obviously as soon as I rename "Sheet 1" to "January" all the links display "Reference not Valid" as it is linked to "Sheet1". Also if I create a copy of "Sheet1" and name it "February" the links go back to "Sheet1" in the same workbook.

There must be a way to link hyperlinks to new sheet name?

I would really appreciate some help on this as I have a serious deadline and have been searing for a solution online for the last 7 hours with no success.

Thank you in advance