Is it possible to set up a Google spreadsheet so that rows with a certain value from another table are automatically added to it (from 10 sheets to 1 total)?

Question

Google Sheets

There is a need for rows whose cells take certain values ​​to be automatically transferred to another sheet. The total number of sheets from which I want to pull data is 9

Answer 1

1) Import everything into a table. IMPORTRANGE function and you can also use an array literal

=arrayformula({
importrange(id1;range1);
importrange(id2;range2);
importrange(id3;range3);
importrange(id4;range4)
})

2) Apply a filter. Function FILTER(easier) or QUERY(faster)
=query(arrayformula({data});"SELECT * WHERE Col1 IS NOT NULL")