How can i use the contents of a cell inside a formula that references another cell on a different sheet.

ie, On my sheet the contents of A1 is "Myname". Now in cell B3 I want to use the contents of A1 in my sheet reference.

For example, instead of =Myname!C23

I want something like =A1!C23

Can it be done?