Data selection works, paste option doesn't

Hello, folks. If I goof this up, please pardon me, new guy here.

I have a database workbook with one sheet to help speed up the data entry process. It may be crude at the moment but it keeps it simple for the end users. Problem I have at the moment is I finally got the macro, "moveit", to select the correct tab to paste to but I get errors on the pasting options. I'm missing something small I can feel it. I was hoping another set of trained eyes can see my problem. I can tinker my way thru Excel but far from being good. Any help would be fantastic. I'll attach a copy of the workbook instead of pasting code to keep it simple.