I am tying to use Indirect to build a dynamic statement. I keep getting the #REF error and I haven't been able to figure out how to do it correctly.

I have the pieces of the reference in different cells.

A1 = MW
A3 = 01

and the cell on the tab I want to reference is L27 (just for kicks it equals 3,003)

I am constructing the Indirect statement as such:

Formula: copy to clipboard
=INDIRECT(" ' " & A1 & CHAR(32) & A3 & " '!" & L27)


and I need it to return this:

Formula: copy to clipboard
='MW 01'!$L$27


Any help would be greatly appreciated. Thank you!!