sorting names from several sheets into new sheets

What is the purpose of putting the students into groups? What is the purpose of changing groups?

The reason for the questions is to assess the type of solution.

My first thought is to have a single student list where the student ID, Student information and group are in the same row:

Then use the Organize feature "Categories" to make the groups:

You can use the Categories slider to enable and disable the groupings

Ralotoft wrote:

We have a Genius hour every week at school, where students can dig deeper into a project they are working on. Depending on the project, they are assigned to a specific teacher/group. When they move on to the next project, they might change group, but we still need to keep track of where they are.

You need to keep track of where they are. Do you also need to keep a record of where they were (i.e. past groups)?

SG

Please remove real student names and information and post a screenshot of what you have.

Then using the Categories feature, as Wayne describes, should be an excellent approach. It doesn't depend on having a student ID. And you can call the groups whatever you want to call them (i.e., they don't have to be a number). You can just turn Categories off whenever you want to see an ungrouped view again.

SG

grouping and sorting across sheets and tables will be difficult. I would not start down that path if I were you. I would start with a single table of all the students and have the information flow to other tables based on the content in the "Student List"

Maybe consider something like this:

Categorized for Sports: