I am working on building a database in excel that collects information for fantasy football. I have a worksheet that has the players names and positions on them, and then I have a separate worksheet for each of the individual positions. So the main worksheet has quarterbacks, running back, receivers, etc. all on one. Then there is an individual worksheet for each of those individual positions.

I am wondering if there is a way for the individual position sheets to automatically update if a new player is added to the main spreadsheet. If I were to add Drew Brees, QB to the main players list, is it possible for him to automatically show up on the QB list?

Thanks