Drop-down-list based on what cell contains

Ok, so next step:

I want drop-down-list from a list in another sheet. If Cell x contains "text", then go to Sheetx > find Column B > make a list where it contains range from x to xx
And... if it contains "text2" then range xx to xx

So here is my case:

(sheet1) IF L1 = "Eiendeler", go to (sheet2): Column B: list opp all cells that contains 1000-1999.
and
(sheet1) IF P1 = "Eiendeler", go to (sheet2): Column B: list opp all cells that contains 2000-2999.
and
(sheet1) IF T1 = "Eiendeler", go to (sheet2): Column B: list opp all cells that contains 3000-3999.
and
...
...
...
...
...