Possibly
Look at the hyperlink worksheet function in Excel help.
If that won't work, then you will depending on how data is entered and what
would trigger the creation of a hyperlink, you would look at the change
event.
http://www.cpearson.com/excel/events.htm
for an overview of Events (Chip Pearson's site)
--
Regards,
Tom Ogilvy
"Corey" wrote in message
...
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