have you tried "asap utilities' its a free excel addon that makes the large
tedious functions a lot easier. you can just google it and download. it works
awesome.

asap will allow you to create an index sheet (1st work sheet) with hyper
links to each of your sheets/tabs.

"LavenderBush" wrote:

Hi,

I'm working on a spreadsheet that will probably have 20+ worksheets. I'd
like to make this as 'idiot proof' as possible. I want to create a worksheet
that has clickable links to the page the User wants to view - Can this be
done?

Thanks in advance