I have about 100 cells that have hyperlinks to another sheet in the workbook.
If I change the name of the destination worksheet, the hyperlinks no longer
work. Is there a way to change the hyperlinks en masse to the name of the
renamed worksheet before I change the name of said worksheet?