exporting excel data to word template (from excel)

I'm on day 3 of trying to get this to work through applying numerous different approaches I've found online, but none have worked for me. I'm trying to update a word template with data from an excel spreadsheet. The end result is almost identical to what a mail merge would do for me, but unfortunately, I cannot use a mail merge for this exercise.

I've included the sample spreadsheet and the sample template, and any assistance would be helpful.


I'm working with this code, but it is only inserting the employee name:

HTML Code: 

I'm open to the idea of forgoing word all together, and using excel for everything. I envision this could be done by creating a template document on a spreadsheet and then looping through each row to save each file as a PDF, but again, my VBA knowledge is not sophisticated enough to accomplish this.

Thanks very, very much.