I see that you can apply a "Hyperlink" to a cell in a workbook, that when
clicked, will send you to another page in the same workbook. Is there a way
to take the contents of the linking cell to the distination.

I have a large Spreadsheet with many clients. The data for eack client can
be substantual and spread across a single row. I would like to be able to go
to this list, click on the client account number and be taken to another
spreadsheet with only that client's information displayed in a neat form.

From my viewpoint, that could be done by creating a hyperlink, established
on each of the client's account numbers, linking it to a generic spread
sheet that would display only that client's information. For this to work,
you would need to take the account number with you to the generic form so
the form could go back and lookup all the pertinant data from the source and
display it on a single, easy-to-read form.

Any ideas?

Craig