The usual way to reference a sheet is here but how do you reference a sheet when the sheet's name is a value in a cell?
A1 = "Sheet number two" B1 = A1&"!B4"
Here I want B1 to display the value in
'Sheet number two'!B4 but it's not working for me. Any ideas?