You can VSTACK() all your tables, and then use FILTER():

=FILTER(VSTACK(table1,table2,...) , INDEX(VSTACK(table1,table2,...),,2)="N/A", "no N/A")

Table1

Table2

Output

Or slightly easier to maintain:

=LET(_data, VSTACK(table1, table2, ...),
Filter(_data,INDEX(_data,,2)="N/A", "no N/A")

Where 2 would be your column number which could contain N/A.