Hyperlink list

Hi
I am a newcomer to this forum. In fact I'm quite new to forums generally.
So I am hoping that I have done things by the book.

I have a question.
I used to use Microsoft Front page.
On the hyperlink view I could see the entire Hierarchy of all the links on my webpages.

I need to do a similar thing with my Excel workbook.

I have a workbook with many worksheets.
some worksheets have hyperlinks to other worksheets (in the same workbook).

I need to display a Hierarchical list of all the links.

Here is how I foresee the process:-
- Select a 'main' worksheet
- Select a hyperlink (but don't actually go there!)
- List of all the hyperlink ahead of this.
List on a new worksheet will be OK.
They will be listed by the using the content of the cell as the friendly name.

I can't find any reference to this technique anywhere on the internet.
I don't mind using VBA if anyone can assist.