Creating automatic/dynamic drop down lists from a table with multiple variables

sample.xlsx

Dear All,
I’m going to try and explain as best I can the two issues I’m currently having.
I have attached a sample workbook to explain.
I have a large database from which I have currently created dropdown lists manually. However, this is not ideal because I have to update my database regularly and some lines might disappear/appear, which can create issues with regards to the already created manual drop down lists. (time consuming to update the dropdown menus, additionally I have to put the data in the right order before I can start created dropdown menus…).Therefore, I would like the drop down menus to be updated, through VBA, when new data is integrated by looking at the content of column B. In other words, if a cell in column B is equal to a particular word, then the content of the cell in column A needs to be included in the dropdown list, for which a name shall be allocated.
Once the dropdown menus have successfully been created, dependent dropdown menus will be created like shown in the sample workbook.
The second query is more or less the same, but now in a different order. So by selecting a “zzz” you should get a dependent drop down menu “yyy” which would give you a further dependent drop down menu with “xxx”.
I don’t know whether my explanations are clear in any way but any help would be greatly appreciated!
Thanks !

Yes that's correct !