creating word docs from a userform on excel

[gherzberg]

I have a complicated user form that I hope to be able to use that would automatically create two word documents based on the information entered into the userform and templates. This would be the format
Broker [dropbox1]
Symbol # of Shares Price
1 [textboxA] [textboxB] [textboxC]
2 [textboxA] [textboxB] [textboxC]
3 [textboxA] [textboxB] [textboxC]
4 [textboxA] [textboxB] [textboxC]
5 [textboxA] [textboxB] [textboxC]
Settlement Date [dropbox2]
In dropbox1 there would be 4 options “WFABK” “MSKR” “MLCA” “OPCO”. Each option would have two of its own word document templates attached to it. Which are same in form for each option in the dropbox, but with different routing information. These templates are attached as template 1 and template 2. The information in the several textboxes are used to populate the highlighted sections in the templates.
For template one the space highlighted in green would need to equal the sum of all 5 rows textboxB * textboxC. So if in Row 1 of the user form textboxb=100 ,textboxc=10, and in row 2 textboxb=500, textboxc=1, the sum that shows up in the green highlighted section would equal $1500.00. For the section highlighted yellow the sentence, “(textboxB) Shares of (textboxA)”, needs to appear for every row that is filled. So if 3 rows are filled then the sentence would repeat itself 3 times with the appropriate rows information. For the section highlighted pink, it needs to equal the days date that the document was created.
For template two the yellow and pink highlighted sections should be exactly the same as in template 1.
If possible it would be extremely helpful if this could also be connected to a sheet in the same workbook called “Calendar” in which information would be entered into the next available row. With column A = the days date when entered. Column B = the title from dropbox1 (“OPCO” “MSKR” etc.) column C= all entries into the 5 textboxA’s separated by a space. In column D= total price that was indicated in the green highlighted section of template one. In column E it will equal the value in dropbox2.