It is possible to share content between worksheet based on rules

[!Jumala!]

I have a master pipeline and in the Status column there will be terms such as "closed", "approved", "pending", etc. I also have additional worksheets in the same workbook titled "closed", "approved", "pending", etc. I want to be able to look at the master pipeline and see everything that was input and have the "closed" rows copied to the "closed" worksheet, the "approved" copied to the "approved" worksheet, etc. How can I do that?

[AnitG]

I am really a beginner, so I have no idea what the article is telling me. I can attach the workbook if you think you can help me fix it. I am too looking for a same support. Anyhow what I had seen that Excel does not provides any rules things.

[Shurod]

This can be done via macros but I do not thing that it is easy to find the code for this. Try to contact some expert of it. You will need a full fledged working vba code.