HYperlink Worksheet Function..

I have a total of 4 sheets and 1 sheet named as Total.
In the Total sheet I have the put the names of other three sheets excluding Total.

For ex:-
1. Tom In B2
2. **** In B3
3. Harry In B4

Now I want to actually go to the other sheets from there..
I know how to use the Insert Hyperlink but these sheets are going to increase..

So I want to make use of the Hyperlink worksheet function but somehow not able to do so..

So that i can move TO & FRO from the Total sheets without manually doing that...

Can anyone guide me ? Please provide the explanation as I have tried going thru the MS Excel explanation but nothing seemed to work..

My formula In C2 would be
=HYPERLINK(LEFT((CELL("filename",$A$1)),LEN(CELL("filename",$A$1))-LEN(RIGHT(CELL("filename",$A$1),LEN(CELL("filename",$A$1))-FIND("]",CELL("filename",$A$1),1))))&"Tom"))&B2,A1)


The portion [ HYPERLINK(LEFT((CELL("filename",$A$1)),LEN(CELL("filename",A1))-LEN(RIGHT(CELL("filename",$A$1),LEN(CELL("filename",$A$1))-FIND("]",CELL("filename",$A$1),1)))) ] plus "Tom" is the Path and the friendly name is B2..

Please please help me on this....



The information provided in MS Excel...
--------------------------------------------------------------------------
Syntax

HYPERLINK(link_location,friendly_name)

Link_location is the path and file name to the document to be opened as text. Link_location can refer to a place in a document— such as a specific cell or named range in an Excel worksheet or workbook, or to a bookmark in a Microsoft Word document. The path can be to a file stored on a hard disk drive, or the path can be a universal naming convention (UNC) path on a server (in Microsoft Excel for Windows) or a Uniform Resource Locator (URL) path on the Internet or an intranet.

--------------------------------------------------------------------------

all4excel