I need to copy/import lines from all sheets into one different sheet based on multiple conditions.

In other words, i need to automatically copy/import, from all existing sheets on spreadsheet, the lines where column B is "fruit" and column C is "red".

I can import the lines from Sheet1 like this:

```
=FILTER(
IMPORTRANGE("1HXbrA_Ks8yuIit6UOBdZEdan3hSRGnnuGvrIueDCbXM";"Sheet1!A2:C") ; 
           (Sheet1!B2:B = "fruit");(Sheet1!C2:C = "red")
)

```

But i need to import the correponding lines from all the existing sheets.

Maybe using a script is the right way to achieve this, but i am not able to do it.

Here is a live spreadsheet for testing:

<https://docs.google.com/spreadsheets/d/1HXbrA_Ks8yuIit6UOBdZEdan3hSRGnnuGvrIueDCbXM/edit?usp=sharing>

This test spreadsheet have only 2 sheets, but the real spreadsheet have several sheets, so please take that into consideration.

Thank you very much.