Copying from one table and inserting the data multiple times into another

[WxShady13]

I have a spreadsheet that takes training attendance for up to 16 modules (there is a 4a and 4b between 1 and 16 also). I have the code written so that when a name is entered, and a user chooses the appropriate modules that have been completed it writes properly to 2 other worksheets. The problem I am running into is that the last worksheet I need the data written to is in a specific format so it can be uploaded to our ERP system. The upload worksheet lists the individual employee 17 times in one column and lists each Module along with the name on each row. The last column indicates the date the training was completed, or if they did not complete the training it just says Null. I realize I could just copy the formula I have on the last worksheet down about 100 rows and be good, however others will be using this spreadsheet and are not as computer savvy. How do I use VBA code to write the employees name 17 times but only write the employees listed on the previous spreadsheet (CBT Modules)?