Yup - bad paste on my part:

=INDIRECT("'[" & A1 & "]Sheet1'!G26")

In article ,
"Cathy W" wrote:

Hi. Thanks for the response.

It gives me the error "That name is not valid" and highlights the "'" quote
in the formula.


"JE McGimpsey" wrote:

Try

=INDIRECT(["'" & A1 & "]Sheet1'!G26")