Local Australian with extensive VBA/Excel experience in operational excellence, reporting and analytics. Ive worked as an operations analyst at some of the biggest ecommerce companies in Australia/globally (eBay, Groupon) creating automated solutions to drive optimisation.
I often set up automated data entry databases controlled by userform interactions. Depending on the type of criteria you need to drill the data down with, there are quite a few option on how to best present the form so that it is as simple and efficient as possible (list boxes, drop down, multi select combo boxes, inputs for range) - the main thing is that it sounds like you want the options to be dependant, and I can definitely arrange it so that you have a dynamic and dependant form which eliminates irrelevant options as others are selected.
I have a bunch of examples to share with you that have all the functionality you require. I tailor make all components of this process on the front end elements and visual design and back end (scripting and automation) to achieve the most efficient, simple solution. Im sure I could do the same for you.