Maybe you could use Data|Validation and use dependent lists.

See Debra Dalgleish's site for some instructions:
http://contextures.com/xlDataVal02.html

Tree wrote:

I need to make a drop down list that changes options to choose based on what
is chosen in other drop down lists.

--

Dave Peterson