I know this is a simple issue, but I want to make sure it is correct

I have a workbook with several macros for creating a PDF of reports. The issue I'm having is, if a page is copied to creat the same report for multiple vendors. The create pdf button makes a pdf of the original page not the copy.

I assume it this line causing the issue "Sheets("ToyotaMO").Activate"

Is there a way to change it so if I copy the page and press the create PDF button it generates that page not the original?

Thanks