Hide worksheet and show only when selected

Hi all

What I have is a worksheet that I want to hide, and when a user of the main sheet clicks a button I would like the hidden sheet to then be shown in a seperate window which is sized to that of the set area of the work space of that sheet.

I hope I'm makig sense here.

Plz help!