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
...
...
...
...
...

You probably need to use named ranges for this. But we would need to see some sample data to be more specific.

upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

You may have overlooked that I said "upload a small (clean) sample workbook (not a pic)" ?