Pull Data from Sheet Based on Criteria -- Populate UserForm & ask for Missing Data

This is beyond my current VBA expertise having never worked with userforms before and I can't find anything similar on the internet.

I have a spreadsheet that is updated weekly -- but every week new info is added that needs a user to input corresponding info. I use a vlookup function to link to another spreadsheet that populates the info from previous weeks and the info that is missing shows up as #N/A...

First I was using a msgbox function to get the info:

HTML Code: 

But it can be up to 30 different new employees... and that is time consuming.

I would like to make it more user friendly by creating ONE userform that displays all of the employees as labels -- has a text box in which to put the ID # -- and then has a drop down box to choose the type of employee (2 options). I want all of that info to go back to the reference spreadsheet so it will be saved for following weeks, and then redo the vlookup to get the info into the new weekly spreadsheet (I can do that part)....

I'm completely stumped on it though... the code I have so far is pitiful:

HTML Code: 

Hello --

If I were the end user I would do it the way you say... however, I'm designing this for people who are not Excel proficient at all... and I've discovered (from previous projects) that the simpler I can make it for them, the less problems I have and the less they call me saying they are stuck.... hence the userform idea. The goal is for them not to have to do anything else in Excel other than literally open the file & press a button & enter the necessary info in the simplest most user-friendly way possible.

I do have to have a separate workbook because we receive a new file every week from the client, so I cannot control what is in their file. I can only keep records from previous files to pull from. That part all works fine though -- I have that coded.

I can't upload the sheet because it has confidential info unfortunately.

I could... following your train of thought... is it possible to pause the macro -- let them enter the information directly into the sheet & then continue?

Trust me when I say that the end result has to require VERY LITTLE knowledge of Excel for the end user even if it is more work for me at the beginning...

Any suggestions are greatly appreciated!

Okay here is a stripped down version:

Template File is the file we receive from client
Template 2 is the file I have the previous weeks data in

I use Template 2 to populate the ID info for new file received

Then I need new employees (represented by the last line in Template File) to have their info updated in Template 2 & Template File by end user before the rest of the macro continues (purpose of macro by the way is to create ASCII file for upload into system to eliminate having to input time manually)

Then it reformats and splits out the info into two separate ASCII files for upload into system (p.s. there are a lot more employees than on this sheet thus the macro)

I still have to find a way to tell it which employees to put in the ACH batch because I wrote it one way yesterday but it was incorrect & now I have to redo it.

Here is the code (please forgive me -- I am a novice --- don't judge too harshly!!)

HTML Code: