Sheet names which contain spaces need to be placed within single quotes.

If

A2: My Sheet Name

then

"'"&A2&"'!$B$2:$B$120000"

is resolved to

'My Sheet Name'!$B$2:$B$12000


In article ,
"Al" wrote:

So all the quotes on either side of the & symbols are for what?