dynamic hyperlink with cell references

[keeborts]

ok i was wondering if this is even possible.
i want a hyperlink to reference to the contents of another cell example

REFERENCE TABLE

| A | B |
1 |Alexander | Sheet1 |
2 | Alona | Sheet5 |
3 | Alfie | Sheet3 |


Column A is the hyperlinks. column B is the exact name of another worksheet in this workbook. i want the hyperlink to reference to the cells in column B so when the hyperlinks are clicked the active (or visible) sheet is the sheet being referenced. example, when cell A1 (Alexander) is click it will take you to (reference B1) Sheet1. is this possible? i know i can make a simple hyperlink by right clicking and going to hyperlink and then just choose the "place in this document" but i have many many many many hyperlinks to make, i was hoping i can do it formula wise.

[davesexcel]

Here are a couple of threads
http://www.excelforum.com/excel-work...-function.html
http://www.excelforum.com/excel-gene...-function.html