MS Word Template with dependancies driven by excel (VBA)

Create for office 2013 and above (but specifically 2013 users on networked enviroment with no admin access to windows) Spreadsheet will generate a word doc template dependent on drop down selected and placed in a specific part/paragraph of word doc. Everything needs to be editable for future including the drop down lists in template tab will reflect same name as workbook tabs if changed When creating template, it will also “Save as “by default as Job title name field “Save to” by default to desktop And after "created template" is selected and generated the new doc will open for review template drop down b4 cell – date will always be recorded correct date format regardless of input Count tab: Any calculations to support selections in template builder eg: how many templates generated NOTES: · All grey text in word docs is sample of what comes form template (for your example only) · Anything in black stays on template as default text · IN TEMPLATE TEXT IN red will not appear and are only there for your view purpose · 3 tabs - If name is changed of Tab it will also change name in template builder menu cell B6