Hi,

maybe

=INDIRECT("'"&A1&"'!"&CHAR(COLUMN(C1)+64)&COLUMN(E1))
Hope that helps