I am using a Filter function on my master sheet and populating data from master sheet to sub-sheets basis then criteria. When a criteria is satisfied the sub-sheet gets populated ; this sub-sheet has some manual data linked to each populated field.
I am using INDEX(FILTER) formula to populate the sub-sheet

This formula breaks when any data between the two previously populated field satisfies the condition, as the shift the table thereby distorting the manual entries mapped to the fields.

I want to create a logic that when any data from master sheet fulfils the criteria it should populate the last empty row of the array in the sub-sheet rather than populating the value in between.

IN case any further clarification is required please reach out to me