Help with Excel report creation for review results from multiple worksheets...

OK so I think maybe in your RESULTS table the 'met expectations' column might be a little different or something and therefor the conditional check might be 'passing' when it shouldn't and besides it seems all we care about is if the # reviews is >0 so try this:

=LET(filterBy, RESULTS!A2:C2,
     resultTable, RESULTS!A5:E12,
     columnCounts, {5,6,5,5,5,7,6,7},
     report, LAMBDA(result_filter,result_row,table_all, LET(table_data, DROP(table_all,1),
                            table_matches, (CHOOSECOLS(table_data,3)=INDEX(result_filter,1))*
                                           (CHOOSECOLS(table_data,2)>=INDEX(result_filter,2))*
                                           (CHOOSECOLS(table_data,2)<=INDEX(result_filter,3)),
                            IF(N(INDEX(result_row,2)),
                                VSTACK("*** "&INDEX(result_row,1)&" ***",
                                       TAKE(table_all,1),
                                       FILTER(table_data, table_matches, "")),
                                ""))),
     total, REDUCE("",SEQUENCE(ROWS(resultTable)),LAMBDA(p,q,VSTACK(p,
                 LET(tbl, INDIRECT("tbl"&TEXTJOIN(,,TEXTSPLIT(INDEX(resultTable,q,1),{" ","-"}))&"[#ALL]"),
                     report(filterBy, CHOOSEROWS(resultTable,q), CHOOSECOLS(tbl,SEQUENCE(,INDEX(columnCounts,q)),SEQUENCE(,2,COLUMNS(tbl)-1))))
                 ))),
    IFNA(IF(total=0, "", total),""))

 and not to beg for likes but feel free to give me some if you like