Pulling values from one tab to another in descending order, skipping null values

I have values in one tab, call it RAW DATA. The values are culled from the main data dump using a date criteria. I need those values transferred to the main tab, in descending order, ignoring the null values.

Attached:
Main Tab - Where I need the data to go into
Raw Data: Column A through H is raw data i drop in

I need a formula that will take the first viable data point in RAW DATA tab, column AH, and drop it into MAIN TAB cell B2. Then the next viable data point in B3, etc. And so on for the next 4 days.

The QTY is just a VLOOKUP, but I am really having trouble figuring out the transfer of the LOAD # data.

Suggestions? I tried a ton of different formulas, including:
=IFERROR(INDEX(OUTBOUND!$AH$2:$AH$100,SMALL(IF(OUTBOUND!$AH$2:$AH$100<>"",ROW(OUTBOUND!$AH$2:$AH$100)-ROW(OUTBOUND!$AH$2)+1),ROWS(C$5:C5)),COLUMNS($C5:C5)),"")

This got me close, almost there.

Last bit: I cannot use VBA or Macros, the computers running this are vastly different, and not all have the ability to run Macros or VBA, so i have to do it the long way.

In B6

=IFERROR(INDEX('RAW DATA'!AH$2:AH$100,SMALL(IF('RAW DATA'!AH$2:AH$100<>"",ROW('RAW DATA'!$AH$2:$AH$100)-ROW('RAW DATA'!$AH$2)+1),ROWS($AH$2:AH2))),"")

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.


Copy across and down

Thank you! What is the purpose of the following section? I think i dissected the rest to understand it, but I cannot figure out the purpose of this?
=IFERROR(INDEX('RAW DATA'!AH$2:AH$100,SMALL(IF('RAW DATA'!AH$2:AH$100<>"",ROW('RAW DATA'!$AH$2:$AH$100)-ROW('RAW DATA'!$AH$2)+1),ROWS($AH$2:AH2))),"")

ROWS($AH$2:AH2)) is simply a "counter": the first value $AH$2:AH2 is 1; when formula is dragged down we get $AH$2:AH3, $AH$2:AH4 giving values of 2. 3 etc.

This is used as the second parameter in the SMALL function so we the 1st (non-blank) value, then the 2nd, 3rd etc. note the first element $AH$2 is an absolute (static)reference, while the second (AH2) is a relative (dynamic) reference.

You could use ROWS($1:1) where it is (I think) more obvious what this count is doing, so we will get ROWS($1:1), ROWS($1;2) etc