Yes, many of us here can do this stuff. It is not a quick forum answer. Many here spent weeks or months on each technique to master it.
But dependent dropdowns have been covered here, perhaps a search would reveal.
As example (rough draft only) I've done things like:
https://drive.google.com/file/d/0B1_PFw--3o74TC16eXRBYXZBNFk/view
and reports
https://drive.google.com/file/d/1R3VtCPpQ0JP3q7dpjt4M69eYFLPenMU_/view?usp=sharing
Personally, I usually prefer a lookup table instead of a dropdown. Because, you could have a few hundred entries, and a lookup table will allow for a search box.