referencing worksheet by text in cell

I am trying to find a simple way to reference a worksheet by text entered into a cell. In this example I have multiple worksheets named after different stocks supporting a presentation sheet, which will occasionally reference cells e.g. =MSFT!B2. I would like to make the formula change with text entry into a cell in the presentation sheet e.g. if A306 contains text MSFT, formula will look on worksheet MSFT, but if text changes to CSCO, formula will reference worksheet CSCO. Any help would be greatly appreciated.
Chas

Try...

=INDIRECT("'"&A306&"'!B2")

Hope this helps!

That works perfectly

Now is there an easy way to modify the formula so that when you drag it down it reads:

INDIRECT("'"&A306&"'!B2")
INDIRECT("'"&A306&"'!B3")

Thanks
Chas

Try...

=INDIRECT("'"&$A$306&"'!"&CELL("address",B2))

Hope this helps!