Nested IF with Offset and Aggregate function together

I have a larger data source (not in my sample) that is consolidated into helper columns (U:AC) with a reference cells in column T. In my actual excel document this helper cell will change based on the input in cell B6

what I am looking to do is move the data into the corresponding columns based on the area that they fall under.... Technical (E:G) Tactical (H:J) Psych/Self (K:M)
I am able to move data over using this formula

=IF('CAMP PLANNING'!X2="Technical",OFFSET('CAMP PLANNING'!AB2,'CAMP PLANNING'!$T$3,0),"")

but the issue I am running into is it isnt putting it into the correct order and if I move this formula over to the Tactical or Psych columns it wont show any data. I am assuming this is because it is just showing the data from the first, second, third...... and if it doesn't match the if function it show blank.

What I want it to do is to put the data into the proper order High - 1st, Med High - 2nd, Med Low - 3rd, Low - 4th. and if there is say no High it will start with Med High. I am assuming that the aggregate function would be the best option to sort this but I am not able to get it nested into a proper working function with Offset and IF together

the blue highlighted box is what I want the actual data order to show prioritizing the high to low column in row 11 to 24

Hey...From what you want to accomplish, isn't it much better via using pivot table?

In your case, it'll be 3 different pivot tables

no a pivot table wont work for what I am doing with my final document.

This is what I've done. And since you have a formula on your data, I make is as values so that you can see the pivot takes the data from the source

Pivot tables are not what I am looking for