I have on sheet1(Enter-Exit Page) a list that grows as new sheets are added,
that displays a cell value.
They are displayed in the range O4:O48, as this is the MAXIMUM number of
sheets that the Workbook will contain.
However i want to be able to have the values displayed on the Enter-Exit
Page as a hyperlink to the particular worksheet that value is from.
How can i do this, considering that there amy only be a few values, until
eventually O4:O48 will have values.


Regards

Corey