Thank the both of you for a response. What my long term goal is to read the cell value (which I now have examples of doing such) and use that as the worksheet name to hyperlink to. I am googling on how to do this exactly, but I see that it can be done. My data is similar to this set-up
Blue 16

So I have a worksheet named Blue - and I want the number 16 to be a hyperlink to the worksheet Blue.