using pop-ups and referencing in other sheets

Here's what I want to have happen:

on sheet 1, I have a column of pop-ups that list, say, a letter grade A-F.

on other sheets I want to automatically have all the A's show up in a table, B's in another table, and so on like that, each with all the row information (first and last name, grade, etc...). Is there any way I can do this?

What I want can easily be accomplished using the reorganize window. I'm just wondering if I can get it to do it automatically on separate sheets.

thanks!