How to import data into Word template from excel workbook with multiple sheets

Hi I have an excel workbook with a word template file.

I need some of the data from that workbook to be inserted into a new word file created when I click the Export Data button in the Data Input sheet in the workbook.
The data cells in the workbook would then be added to the matching cells in the tables inside the template. I could then save the template file as a word document with a proper name.

Kindly let me know if you guys have a solution using vba macros.

Thank you very much.