Formula - Copy rows based on text from another sheet

Question

Hello,

Is it possible to copy a row from one sheet to another one IF its contain one special text?

I have some product from different manufactors, and I only want one of them in my second sheet. I have found ways to sort it, but not in real time.

Like in this first picture I got some few products. When I choose them, I want it copied to my second sheet in real time and only one of the manufactors.
[img ]https://i.ibb.co/fYDrJfQ/Main-sheet.png[/img]

This is the second sheet were I want the names sorted out, and only from "Solar"
[img ]https://i.ibb.co/h2J5LXT/Second-sheet.png[/img]