The following utility program may help you to navigate your 80+ sheets.
http://www.xldatasoft.com/downloads/SortSheet.xls

You need to enable macro in order to make it work properly.

--
Best regards,
---
Yongjun CHEN
==================================
- - - - www.XLDataSoft.com - - - -
Free Excel/VBA Tool & Training Material
==================================
"gab2409" wrote in
message ...

I have a book with about 80 sheets(accounts), and I need to do 2
things:
1. hyperlink to each sheet by the sheet name. the name is also in hte
actual sheet

2. have a master sheet with info from each of the 80 sheets. this
will be about 3-4 entries for each account.

the info is from a form, and all of the needed entries are on the same
cells for each sheet. can I use some sort of formula to auto-populate
this info? if I can get the data from all 80 accounts on one sheet, I
can manually hyperlink them pretty easily. thoughts?


--
gab2409
------------------------------------------------------------------------
gab2409's Profile:
http://www.excelforum.com/member.php...o&userid=20483
View this thread: http://www.excelforum.com/showthread...hreadid=549091