How to pass data from a Google Forms sheet to adjacent sheets of a table?

Question

Google Sheets

There is such a simple form https://goo.gl/forms/lhLDKdFmjVGkDV3C2
The user enters two text fields and selects one of the three categories from the list.
It is required that these two text values ​​are immediately filled in the sheets of the table https://docs.google.com/spreadsheets/d/15NFJr5A66_...
depending on the selected category (the names of the sheets correspond to the names of the categories).
Is it possible to do this automatically? That is, immediately after entering the answer, the data is copied to the category sheets and removed from the form sheet?

Answer 1

Yes, it's easy.
To begin with, establish a connection with the table so that the answers are recorded at least somewhere or give access to the table in which the answers go
. Then I'll do it.
For those who need to do the same:
1) Create a separate table where all the answers go
2) Create a table as in the link above with three tabs
3) Create a second table on each tab with a formula consisting of two nested functions:
=FILTER(
IMPORTRANGE("Link to table with all answers";"Sheet!Range");
Filter condition that filters only "Love,money" or whatever you need
)
Answers will flow from the first table and sorted into the second