I do using this part of the macro
' finds appropriate sheet based on info in "C11"
'finds sheet name you want based on "C11"
sheetname = ThisWorkbook.Worksheets("Check out Sheet").Range("c11").Text
? are you saying I have to activate it again, I'm not understanding since I already activate that sheet