Hi Anthony,

If I use =INDIRECT(a1&"!D20") it doesn't pull the value from the relevant
sheet.

If you have spaces in your sheet names, you'll need single quotes around the
name, so something like the following should work:

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

Regards

Stephen Bullen
Microsoft MVP - Excel
www.oaltd.co.uk