How to make a function in Google Sheets that checks all the cells in one column and passes this row to another sheet?

Question

Google Sheets

You need to make a function that checks all the cells in one column, for example, the word "Apple" and if it finds the word "Apple" in some cell, then this function transfers the row where this cell is located to another table, how can this be implemented?

Answer 1

In the first column: =IF('Лист1'!A1="Яблоко";'Лист1'!A1;"")
In the second and subsequent (stretch): =IF(A1="";"";'Лист1'!B1)
Next, you can stretch down. Example