How to import data from another worksheet

[dsutherland]

I have a workbook that has many sheets that are the same format but with differing data. I'm trying to have one worksheet where I bring various pieces of data (single cells) from the other worksheets and sum like data for ease of use and viewing.
What I'm trying to do is develop a way to get to a cell in another worksheet and import it to a cell in my active worksheet using a variable that is contained in another cell in the active worksheet as part of the formula. This sounds like it would be easy but as of now I haven't been able to figure out a way to do it.. Basically what I would like to do 'if it worked' is take the formula mysheet2!$b$5 and replace mysheet with the value in a cell. Say the cell a1 in my active worksheet contained 'mysheet2'. In effect what I would like to do is a1!$b$2 but obviously this doesn't work. Any suggestions??

[NBVC]

Try indirect function,

=Indirect("'"&A1&"'!B2")