how do i map and hyperlink 100 worksheets

Suppose I have and excel workbook with 100 sheets and I want to click from one sheet to another. I created a table of all the sheets and hyperlinked the sheets then copy/pasted the table into each worksheet but that seems primitive. What if I have to revise the table? I will have to do it hundred times !
Is there a smart way to accomplish this using one smart master table that I can copy and paste into each sheet or somehting similar?

thanks

1. Macro would do it
2. To do it in formulas, simply have one master sheet of the hyperlink paths, and have tables on each sheet referencing back to that master sheet. That way, you only need to update the master sheet's link paths, and all dependent cells will be updated as part of the process. To give all sheets at once, make sure they have acceptably similar layouts (e.g. each has the table in cells A1:B100). Then highlight all sheets except your master. Any updates you make will update all selected sheets. So if sheet2, sheet3, and sheet4 are all selected, entering data on sheet2 cell A1 will update A1 for all selected sheets.

Try using the hyperlink function it will allow you to create a hyperlink address more easily and with more flexibility.

see sample

Apoligies,


please try more structured version


regards

baj

Thanks for the suggestions. but i am looking for a 'master hyperlink table of content' of some sort that i can 'paste/insert'in each of the 100 sheets and the Master table would automaticaly update the rest of the other tables on the 100 sheets.