worksheet select

First of all, good morning and thanks to all of you who come on here and help us out and never asking much in return. You've inspired me to go to other forums where I actually do something about the subject and help out. :) I seem to have a sick dog now that is wanting attention so I've broken...

Hello, Getting above error when running the below Macro, and cannot figure out why for life of me. I have searched endlessly, but am new to VBA so hoping someone can assist. I understand the code I've used is problematic due to the use of .select and copying/paste back and forth b/n sheets...