1. Sheet 1 Let’s call it “a” has automatic input using a Google form

2. Sheet 2 Parases the data from Sheet “a” and has a dropdown on Column R that the user can choose to select where that row of data will go to
Sheet 2

3. let’s say Sheet 3 and Sheet 4 are in the drop-down and by choosing Sheet 3 The dropdown Row of Data goes to Sheet 3 but the information that was under the parsed Row it goes to Sheet 4 and the next row goes back to Sheet 3
Sheet 2

4. Sheet 3 Would have an Empty Space between its two parsed rows
Sheet 3

5. Same for Sheet 4
Sheet 4

I want to make it so Sheet 3 has the parsed data one after the other same for Sheet 4 but they change if the dropdown in Sheet 2 changes in real time

What I’ve used so far

=IF('Sheet 2'!$R2="Sheet 3", 'Sheet 2'!$B2, "")

I used this for both sheets to get the data by doing a check first but this might be the reason it’s not parsing them 1 after the other.I am at a complete loss after trying for hours maybe there’s some sort of app script I need to write that I’m unaware of but I am trying to keep it with in formula due to my nature of application in those sheets