Dropdown Combobox dependent on another

Hi all,
I am an excel learner. With the help of excel forum I have downloaded an excel file and working on this to suit my need. I have Three comboboxes in Sheet3. Everything works fine so long the Named Ranges are listed in One Column and divided the list into Named Ranges. But I want to have the named ranges in Multiple column and select the comboboxes list accordingly. The comboboxes are in Sheet3 and the data are in Data Sheet. More explanation and requirements are given in the attached workbook "Drop-test". I am using Excel 2007.
Your kind help will be highly appreciated.

LoknathDrop-Test.xlsm