Is it possible to creat a dynamic hyperlink to an different worksheet? I
want to be able to set the hyperlink to the value of a cell. eg. If cell A1
= LKP-1000i-Bulk then I want the hyperlink to take the user the tab named
LKP-1000i-Bulk. When I update the report next month, LKP-1932xp could be in
cell A1. Now I want the hyperlink to take me to that tab.

Is this possible?

Thanks!
PJ