Create a multi-level table with a drop-down list

Remote work for a specialist in creating tables. You need to create a multi-level table with a drop-down list.
I mean. When you fill in the first column, you should disclose a list of what you can enter. When filling in the second column, a list of only what corresponds to the one entered in the first one is disclosed.
It should also be able to supplement or change the nomenclature on another sheet and sort it alphabetically.