Would endlessly appreciate any assistance from respected Excel gurus on the issue described further.

I have a workbook, where customer data is entered and after specific actions with the client a status is set for each entry. Some of the statuses require follow-ups, thus, in help of a few formulas, I arranged the data of clients with the specified status to be transferred to new sheet. At this point I have 1 main sheet where data is initially entered and 3 secondary sheets where client data is copied if a specific status is set on the main sheet. What I would additionally need is to have these 3 secondary sheets to be linked in between as well the same as with the main sheet, so that if a status on one of these three is the same as where entries from main page are copied they get copied there as well. As an example, I have 5 statuses "A", "B", "C", "D" and "E". A and B do not require follow-ups but the rest do, so they are copied to sheets S1 (C), S2 (D) and S3 (E) respectively. What I want is if on sheet S3 status changes to C the data is then copied to sheet S1. The formulas I use now are the following (on sheet S1):

Cell A1 = status "C"
Cell C1 =B+1, Cell E1 = D+1, F1 =... etc. (the formula is extended to the same amount of cells as sheet 1 has columns of data that need to be copied)
Cell B2 =MATCH($A$1,OFFSET(Main Sheet!$B$1:$B$20,A2,0),0)+A2-1
Cell A3 =MATCH($A$1,OFFSET(Main Sheet!$B$1:$B$20,A2,0),0)+A2
Cell C2 =OFFSET(Main Sheet!$A$1,$B2,C$1) and is extended throughout the number of required rows and columns where data is copied.

Is it possible to amend these formulas so that not only data from sheet "Main Sheet" is copied but also from sheets S2 and S3?

I've attached an example file so that it is a bit more understandable of what I am trying to achieve here.

Thanks to everyone who will help with an advise on this in advance!