Extract Value using indirect Formula

[Howardc1001]

I have the following formula to extract the value from a sheet using indirect formula but where there is a space in the sheet name, It returns #ref!

Please Login or Register  to view this content.

I have attached sample data

Please check & advise on how to overcome this

[Limor_OP]

Try in B1:

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

[Howardc1001]

Thanks for the help Belinda