Please Help - Userform For Item Additions

[CHRISEWRIGHT20]

Greetings Everyone. This is my cry for help as I am stumped with VBA. I should be embarrassed to admit but its true. Okay, I have attached both files that I created which the sales force uses in my company to add "prospective" items to our Oracle database. The "New Item Upload Form" has multiple tabs but I left only one available as a user-form for the sales team. Once they have completed their item request, it gets emailed to another department for review at which time that department runs the 'Macro - New Item Upload' vba to basically pull a hidden tab from the original and preps it with the appropriate format for Oracle interaction.

What I am trying to do is first of all, combine these two files.

Second, take the first tab and create a user-form to be completed.

If possible, create some buttons on that form to send to the final department via out. Their test email is: Parts@adsinc.com

Once the email is received, the "Parts" department can run the 'Macro - New Item Upload' macro with a button that is password protected.

It sounds pretty hefty, I know, and I sincerely apologize. If you look, you can see my feeble attempt with the use of long IF statements so the second hidden tab can contain what the user places on the available tab.

Please help me out. I am VERY open to any suggestions for a different way to go about this as well. I accept any and all constructive criticism. Thanks and God bless.