I'm trying to set up a macro where each time it runs, it inserts a new
worksheet with a hyperlink from the initial sheet to the new one. However,
when I run the macro, the hyperlink always takes me to the worksheet I used
when recording the macro. I think the problem is that the hyperlink I set up
was to a specific worksheet only, so I'm wondering if there is a way to
program the macro to update the hyperlink to the new worksheet each time.

Can anyone help?