Advice for Coding

[vonanne]

Hello,
I am desparately trying to save my coworkers hours of work by creating a document for articulating/deciding where to put our students for the following year. I have one sheet where they will enter the data and then in the last column make their suggestions for next year's class NA-D). Right now, I'm sorting that data and then copying and pasting into a new sheet that has four different sections (A-D). Having the four different sections all on one sheet is important so that we can view it and anaylize for equity. I'm wondering if there's a way for information put in that first sheet to automatically appear on the second sheet depending on the class section. I'm probably not explaining it well...so I'll attach what I have so far. Again, if someone out there can help us with this, you'd have the gratitude of about 56 elementary school teachers and 600 students!
Articulation.xlsx