Try

=INDIRECT("'"&$A$2&"'!K20")



--


Regards,


Peo Sjoblom


"Keep It Simple Stupid" wrote
in message ...
I have several sheets that I need to pull the information from cells K20,
K65, and K79 for each sheet.
On a "Summary" sheet, I have listed the sheet names in Column A.

So far I have tried using versions of an INDIRECT formula, but it does not
consistently work (in fact, the few times it has worked, I can't figure
out
why)!

Here's the formula I was using:
=INDIRECT($A$2&"!"&"K20") Usually this formula comes back as #REF...
What
am I doing wrong????