Excel designer

I need to design a speadshwet to keep track of the office and different teams. I have 5 potential teams and each team has 5 spaces on the teams I want to be able to ask people which team they want to be part of and then be able to track skills for each team. I would like it be be able to have either pull down or drops to be able to select different skills instead of typing them in each time