In Cell A1 I have "Shell", I want to link Cell A4 to the worksheet "Shell",
cell A20.

so that A4 = Shell!A20, instead of this Ive tried:

A4 = "A1"!A20 but this doesnt work - why not, thanks