Yes it can,
When inserting a hyper link, down the left hand side 'Link To:'
Select 'Place in This Document'

Then choose the appropriate Sheet and Cell or Named Range etc.

George

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