In article ,
Tiesthatbind
wrote:

...oddly
it did not hold the ' ' either side of the sheet1.

Since the sheet name doesn't contain a space or other relevant
character, there's no need for single quotes. I put them there just in
case your sheet name differed from the one you posted and contained a
space, etc.