Here is what i'm trying to do:

I need a drop down list so my users can select and apply a filter. The "auto filter" method is a little clunky and allows sorting, which I dont want. So, i'm hoping that I can make a selection with a combo box, then automatically filter based on that selection. Is there a way to do this?