Then try simply:

=INDIRECT("'"&$A$24&$C$24&"'!E23")