Dynamic range acoording to sheet and Material Name

How can I make a dynamic Range,
I have each material in a separated sheet, I need when I select the Material (in combobox "cmbName") make the supplier name (in combobox "cmbSupp") goes to its range automatically according to its sheet

ex. If I select from "cmbName", the value "Leucovorin Calcium", I want "cmbSupp" goes to the range in sheet2 "rngSuppLec"
and If I select another value like "Paclitaxel", "cmbSupp" goes to the range in sheet3 "rngSuppPac", and so on


any help will be appreciated

Thanks...