Jump to a Particular Worksheet based on the current cell's value

The hyperlink method does not work for my workbook. I suspect that is because my worksheet names are not named Sheet1, Sheet2, Sheet3, etc. but names like Ashville, Westbrook, etc.

Hi K m,

In Post No.6 I have said;

The attached WorkBook automatically creates your Summary list and adds Hyperlinks to all the Sheets in the WorkBook on the Summary Sheet. If you add a new Sheet just Click on the Create New Link Button on the Summary Sheet, and the new Sheet will be added with a Hyperlink.

It does not matter what you have Named your Sheets, the Code will Copy the Actual Sheet Name and not Sheet 1 or Sheet 4 etc.

Use my Sample WorkBook and Change it how you want and Click on the Add New Link Button. You will the see that it is actually "Perfect", in that with the HyperLink, you just click on the Sheet name you wish to go to.