made a template that I will use to record daily finances. There are two worksheets that comprise my "MASTER SHEET." Ostensibly, I would copy this template for every working day of the year. Each new day will have new data and a different worksheet name. Everything but the hyperlinks transfers without a problem.

My MASTER SHEET has hyperlinks that link to specific cells within the MASTER SHEET. When I make a copy of this 'MASTER SHEET' I want the hyperlinks to link to the same specific cells within the new copy of the 'MASTER SHEET' which I then need to rename to match the newly entered financial data.


PLEASE help me! I have everything, but this puzzle I cannot defeat. Any help would be much appreciated!