Capture data from TWO tabs/tables with INDEX/SMALL/ROW/ROWS Array

Lo all,

I have the following array pulling data based on a drop down from one tab, I am wondering if I am able to add a second query to add data from another table?

{=IFERROR(INDEX(OrdersWIP[Order '#],SMALL(IF(OrdersWIP[Location]=LocReviewSelect,ROW(OrdersWIP[Location])-ROW('Orders WIP'!$D$8)+1,""),ROWS('Orders WIP'!$D$8:D33))),"")}

The second part would be,

 (how do I link it) IFERROR(INDEX(ProjWIP[Order '#],SMALL(IF(ProjWIP[Location]=LocReviewSelect,ROW(ProjWIP[Location])-ROW('Projects Orders WIP'!$D$8)+1,""),ROWS('Projects Orders WIP'!$D$8:D33))),"")}

I tried using +, got nul. Then I tried "&" and that added two order numbers together from the two tables into one cell for the nine rows that had applicable data on the second table.

Thank you good people