This is a follow up to this question: http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_26451367.html
Background, I have a need to create drop down menus using a Form Controls Combo Box rather than a cell with data validation. The reason for this is because I would like to keep the items selected in the combo box drop down in a UI across the top of ALL worksheets. As such, I will use combo boxes and then create Indirects for the "link cell" resulting from a combo box selection to point dependent cells to. As I'm unfamiliar with combo box form controls let me know if anything I just described sounds dumb/not possible.
Second, I would like your assistance in creating cascading drop downs for the combo boxes, I found that the method describe in the previously linked question will not work for combo boxes. Therefore, I'm looking for an alternative solution.... Let me know what you can do and thank you in advance.
Dummy File is attached.