Hello,

I am a special services coordinator with a school. I am in charge of organizing student caseloads for our specialists.

I have a master sheet that currently lists about 100 students along with their data.

What I'd like to be able to do it this:

In addition to the master sheet, I would like to add sheets for each teacher (4 of them), along with an EXIT sheet, showing a list of students who are exited from the program. Using an assigned number/letter (1, 2, 3, 4, E) for each specialist that could be placed into a cell at the end of each row, I would like for the teacher's corresponding sheet to populate with the student data from the master sheet, thus listing their caseload automatically, without me having to always cut and paste each time there's a change.

I really appreciate the help.