Not sure I completely understand what you want to achieve, but have a look at the attached file. In the three shaded cells, use the dropdown to select from a list of values. As soon as you have selected a value, it will no longer show in the other drop downs. The formulas to create the drop down list are in the same sheet.
Bookmarks