Connect values from sheets to a drop-down list

If I have convinced you to avoid the horrors of the merged cell, then I'm happy. If there's anything more that you need, please don't hesitate to shut. However, if that is this problem sorted, please mark the thread as solved.

Im going to explain the variation of the three sheets now. U can use the same file u posted before. Then one called DD V3. If u see the picture i've posted called "value sorter sheet" and "sheet variation" you'll maybe understand the problem. Will try to explain at the same time.

So first of the value sorter is doing exatly what i wanted. First of the cell in A2 is a drop-down list, here we choose the sheet to analyze, also the names under the years (Cell E6 to N6) are equal to the A2. So when switching the sheet to analyze the name changes under the years. I've done this because if you look at the other picture ("sheet variation") you can see that there are double values for the same year. For this I have added the corresponding name in the drop-down list in A2. This means when I want to select this value the cell isn't jumping one step to the right. Is it possible to get the function to search in coloum and rows then find the intersection instead?

Btw also the state and city ("län" and "kommun" in cells C6 and D6 need to be connected the same way the undercategory and maincategory is in A6 and B6.

Sheet variation
\1

Value sorter sheet
\1