How can you use a variable to reference a worksheet object?

[xmp1]

So the solution appears to be

Activate a sheet when the workbook is open and all seems to work accordingly