For an idea of what's possible, see:
https://www.msofficeforums.com/word-...tml#post119230
The source workbook for the dropdowns is in post #3 of that thread. Some of the coding complexity in the template is a consequence of the way the data were laid out in the workbook and could be simplified with a more suitable worksheet layout.