Macros - a drop-down list with a link to the company

There is a table with the scenes and directions of work. There is a table with the product in which the company seller is indicated. You need to make a falling list, in which will be the values that correspond to the companies with the given line. Previously it was necessary to manually search for the type of direction and enter the cell. Now it’s just a choice from the drop list. The list is addressed to companies and the list of companies can be added and removed.