If you have spaces in the sheet name you must enclose them with
apostrophes, so amend Gord's formula like this:

=INDIRECT("'"&$A12&"'!"&"A50") in B12

=INDIRECT("'"&$A12&"'!"&"A60") in C12

It's a bit difficult to see, so that is <quotes<apostrophe<quotes
after the bracket and another apostrophe between the <quotes and !

Hope this helps.

Pete


On Oct 4, 11:24 am, wrote:

Thanks. That does work if the sheet names is a single word. However,
my sheets have several spaces and some symbols such as ',' and '&'.
How can I use them with this method?

Thanks again.- Hide quoted text -

- Show quoted text -