Fixing Hyperlinks in a Copied Worksheet (on an Apple Mac)

I have scoured this forum’s discussions about hyperlinks in a copied worksheet referencing back to the original sheet.  Perhaps I missed it, but I didn’t find a solution to my specific problem, so I will start a new discussion.  Apologies if a community wizard already answered it.

I have a workbook with monthly worksheets, each showing the transactions into and out of a savings account.  Each transaction goes into (and out of) one of several “virtual” accounts to reflect the purpose for which the money is earmarked, like property taxes, travel, etc. (called Account 1, Account 2, and so on in the attached)

Each month’s worksheet has a section of hyperlinks, each of which ideally jumps to a specific account in the same worksheet.  The attached example contains only four accounts, but my actual one has 23 with 31 columns and 98 rows.  So the hyperlinks are helpful in navigation.

Each month, I make a copy of the latest worksheet and rename it for the new month.

The problem:  the hyperlinks in the new, copied worksheet reference back to the “source” worksheet.  With 23 hyperlinks, changing each one’s sheet reference (Edit Hyperlink...) every month is not efficient.

Question:  how can I (efficiently) make the hyperlinks in the new worksheet reference cells in their new worksheet?

These are hyperlinks that are internal to the workbook, not to external URLs, so DonBici’s Feb 21, 2024 suggestion of a helper column doesn’t seem like it would work in this case, and I am not advanced enough for his VBA suggestion.

Thanks!