Using Addin to select sheets in Active Workbook

I have a macro in an addin that I am calling from a separate workbook. However, whenever I run the code below, it is running the code in the addin, not the active workbook.

Sheet1.Range("A2").CopyFromRecordset rsData

Sheet1 doesn't exist in the addin, so it is failing. How can I get the code to work in the ActiveWorkbbok, and not in the addin?

Thanks

Doing some more digging, it looks like if I have the macro in the addin select cells, it is selecting them in the active workbook. However, for sheets, they are being selected in the addin workbook. How can I get around this and select sheets in the active workbook.