Create Reference from Existing Text and Exact Cell Location

Hi,   I'm trying to create a cell reference using the sheet name and the exact cell I'm trying to reference from that sheet, but when I use Indirect I get a "#REF!".   For example: A2 is Sheet1 ...