Trying to create a way to dynamically reference another worksheet

This one is a little complicated and not sure if it can be done. I have this table

A B

1 project 1 Wash Car
2 project 2 Wash Floor
3 project 3 Walk Dog

I want to be able to click either the project number or project description to go to a worksheet that has the indepth details of that project. Easy enough, but B1 is going to change at some point. Wash Car will be completed, and a new project will appear in that cell, like Paint House. Is there any way around having to move all the data to another worksheet or renaming the worksheet. Is there anyway to do this automatically and dynamically based on Column A or B's Value. I know I have to build each worksheet out with the details in advance, but I can have 10 worksheets ready to go with templates. Am I making sense? Thanks!

So then what would i would i name the worksheet I want to navigate to?

.
I know you said you did not want to have to edit the Sheet Tab ... but, here is a macro that automatically creates a menu hyperlink to all sheets when they are added to the workbook. Then, if you edit the
Sheet Tab name, the menu name is changed automatically.

Please Login or Register  to view this content.