Create Context Sensitive, easy to use form

I now have a homemade form in Microsoft Word and it works terribly. I need someone to create a form in a common application (I like to use Microsoft Office apps like Word, Excel, etc.). The form needs to easily tab from port to port using the Tab key. When you land on a port, you should be able to type the first letter or two of a selection and it should filter the list to only those selections that begin with those letters. Also, the list should be context-sensitive with other selections one may have made. For example, let's say Port#1 has with color options red, blue and green. If I choose red in that port, then I need to be able to tab to Port#2 and see only shades of red (such as maroon, burgundy, etc.) I should not see the other shades of blue or green as available in that port. Again, this needs to be done in a common and easy-to-use application. Once someone shows me the best way to do this, I will create several of these forms myself.