How to set up mutual feedback between the sheets of a table?

Question

Google Sheets

Good day.

The bottom line is, I have 1 parent sheet with data and 4 child sheets into which data is imported from the parent, each with its own condition. In 4 child sheets, in addition to the imported part of the table, there is a functional part, with the choice of positions and other assignments. New rows periodically come to the parent sheet, and there is an additional column with the status of the row.

The essence of the question, when changing the status in the parent sheet, the line should be removed from one child sheet and go to the second, but this knocks down the order of the assigned cells in the corresponding line in the functional part of the sheet. Suppose, in the sheet where the line should go, I can leave it and mark it as superfluous. But in the sheet where the line came, it will knock down the order of the lines that came earlier with the assignment order in the functional part.

Can anyone suggest a way to implement it?

Answer 1

Use the FILTER function .
Let's say you have data in column A, and their status in column B and can be 0 or 1. Then the formula will be as follows:
=FILTER('Лист1'!A1:B999; 'Лист1'!B1:B999 = 1)
By changing the status, you change the number of displayed rows on another sheet. And the functional part, which, for example, is in column C on another sheet, can easily work with A and B through relative references to them.

Answer 2

1) Use FILTER to extract data.
2) To mix inextricably data from different sheets, you can use an array declaration

={
{"Строка1Столбец1";"Строка1Столбец2";"Строка1Столбец3"}\
{"Строка2Столбец1";"Строка2Столбец2";"Строка2Столбец3"}
}