I have an index page with hyperlinks to different worksheets. I need to update the worksheet names each month with different company names (it's a monthly survey and the companies surveyed change each month, but the format of the "report" in excel remains the same).

Is it possible to set up the hyperlinks so that they will automatically update when the worksheets they reference change name? Manually changing the hyperlink to reference the changed worksheet name is a bit of a pain.