CopyWorksheet.xls
PPU.xlsx.xlsm

Excel Forum,

I am having what I think are object variable issues and I would like to learn why my macros break down when I paste them from my personal workbook into their respective workbooks. Part of this macro worked in my personal workbook.
Attached are 2 workbooks. In the PPU workbook, my macro executes well until it comes across the .find function. I have tried altering my object variables and format type (adding or taking away ' before the search numbers).

Why is my .find method not working?

If you need further context:
I am trying to fill out the PPU worksheet by playing the macro, selecting each file I need, then using the macro to copy and paste the data.

Thank you for your help. This forum is invaluable and one day I hope my skills are good enough to help others.