Problem:

I've clicked on the 'restore' button in the top right hand corner (between the minimize and 'X' to close buttons) and my worksheet has dissapeared.

Solution:

Press ALT+Minus to bring it back into view

Some further useful tips can be found here: http://www.mvps.org/dmcritchie/excel/excelwindow.htm