Hi, I'm a newbie here - hi to all!

I'm trying to create a spreadsheet with multiple worksheets but to explain this easily I'll just narrow it to two worksheets for now.

Worksheet 1 will list a series of links to files on an external website. On Worksheet 2 (amongst other things) I want the user to click on a cell which itself links through to a specific cell and linke in worksheet 1 and for that external link/document to open without the user opening/seeing worksheet 1.

eg. worksheet 1 links to "www.google.com/fakelink.pdf". This external link could be named as "fakelink"
User clicks on a cell with a link to "falselink" in worksheet 2 and the document at www.google.com/falselink.pdf then opens BUT user does not see worksheet 1 at all which will be hidden

I've tried searching high and low, possibly with the wrong terminology and I can't seem to find if this is a straightforward request and how to manage it via VBA etc?

Many thanks in advance
Rob