Dynamic Data validation and the indirect function

Need a way to indirectly refer one data validation list to another data validation list such that when I select one list, the 2nd list is reduced to only those items relevant to that list. I've enclosed a spreadsheet that more clearly outlines what I'm needing. Would also like to figure out how to sort the lists in alphabetical order in the drop down for ease in selecting.