Cell References

[gavs73]

Hi

Hopefully a quick question, is there a way to reference a cell on another sheet using a formula ?, similar to below:

="Apr!"&"AB"&Summary!J55

i.e. trying to get to this but via a formula =Apr!AB7

Thanks for your help.

Kind Regards
Gav

 

[peterhinton]

=INDIRECT("Apr!"&"AB"&Summary!J55)