Now I'm confused. You keep referring to worksheets - which are Excel properties - and a workbook named "SetListCreator", but then you seem to refer to it as SetListCreator.doc - which implies a Word document.
Perhaps you would be so good as to explain precisely what you're doing and post the code too.
For a macro to Find content in one document and insert it into another document without all the window switching, see:
https://www.msofficeforums.com/128621-post2.html