You can do this by setting up named ranges for each sub-element which use the name of the element chosen, and for the construction which use the names of the sub-element chosen. I can show you how to do this, but where do you want the drop-downs to be located?
Also, it is not a good idea to have blank rows between your data.
Hope this helps.
Pete
Bookmarks