From my understanding, the HYPERLINK formula always needs the name of the
book, even when creating links to places in the same document.
I have created this link in "Book1", and it works dinamically with the
contents of cell B1:
=HYPERLINK("[Book1]" & B1 & "!A1",B1)
You may change any part you need in the formula to direct the link to the
proper cell, and to show the name you prefer.

Hope this helps,
Miguel.

"Larry S" wrote:

I have a requirement to dynamically build/create a hyperlink in a workbook
which would allow the user to quickly move between worksheets. ALL
informataion is contained within the workbook so there is no need (or
desire) to have any external links. The workbook would be laid out as
follows:

Worksheets:

Summary
Project 1
Project 2
Project 3

Each of the Project worksheets would have a project title located in cell I8

On the summary worksheet, each row would provide summary information pulled
directly off the Project worksheet. The worksheet name would be place in
column N therefore all pulls of information from that project would be done
referencing the worksheet name found in column N.

The requirement would be to dynamically build a hyperlink from the summary
worksheet to the respective project worksheet with the link being
effectively the title of the project (pulled for the project worksheet) and
the linke place in column B.

I have tried the HYPERLINK function as the help text implies this will
work - any suggestions?? - Here is information from the Help Text:

You can create hyperlinks within a worksheet to jump from one cell to
another cell. For example, if the active worksheet is the sheet named June
in the workbook named Budget, the following formula creates a hyperlink to
cell E56. The link text itself is the value in cell E56.

=HYPERLINK("[Budget]June!E56", E56)

To jump to a different sheet in the same workbook, change the name of the
sheet in the link. In the previous example, to create a link to cell E56 on
the September sheet, change the word "June" to "September."