I know I can add cells from multiple sheets with the following:
Sheet1:Sheet4!A2

But what if my sheet names have spaces in them? When I add the apostrophe
around the sheet name, I get a #Name$ error.

Thanks!