Excel 2007 Hyperlink Screen Tip Question

I would like to have the screen tip within a hyperlink to get it's "tip" from a cell reference in a separate work sheet. How can I do this?

Thanks for the reply! That is very close solution, but not quite what I would like...

Your solution gives the user the link to hyperlink to, and what the hyperlink should say. I would like one step further to get the "screen tip" to be inserted as well.

By screen tip, what I mean is that when you hover the mouse over the hyperlink a "comment" type box appears showing the "screen tip" that the user enters in the hyperlink setup dialog box. It is meant to act as an additional help tip regarding the hyperlink.

Is there any way to pull that screen tip from another worksheet cell reference?

I take it that there is no straight forward solution for this problem?