I am not sure that this is possible, but I will ask.

I am running a bowling tournament that has many teams (2 people/team) over
several shifts. These teams will be placed in two divisions. I want to list
each shift's teams on a seperate worksheet while combining these into a
"Tourney Standings" sheet for each division.

Is there a way to use the value of one cell to copy the data in other cells
to another sheet? For example, if the team is in division one then copy
their names and total to the "Division 1 Standings sheet". If not, then copy
their names and total to the "Division 2 Standings sheet".