Hi,

There are VBA tricks using Events and Dynamic Named Ranges and Advanced Filters to hide all the OR functionality in your problem. BUT - to use them correctly leads to more problems than I think they solve. If you teach those end users how to use Advanced Filters it will be transferable knowledge to other tables and problems using Excel.

NOW - if you were to attach a sample file with the data design as you have it and how you want it to look, we could do a much better job in trying to answer your question.
To attach a file click on "Go Advanced" below the message area and then on the Paper Clip Icon above the advanced message area.