It will work in this way...

=INDIRECT("'"&A1&"'!C3")