Thank you to anyone who can help.

I have three worksheets. In the first worksheet I have my source data, and
one of the data fields indicates if the data goes into bucket 1 or bucket 2.
For example, lets say the list is people on a bus, and the field indicates if
the people go onto bus 1 or bus 2. I want the second worksheet to be a list
of only the people on bus 1, and the third worksheet to be the people only on
bus 2. I can do this with the advanced filter option. My problem is that if I
change the original data on worksheet 1 (lets say switch someone from bus 1
to bus 2 in the original data), I don't know how to get the lists in
worksheet 2 and 3 to automatically update with this new information.

Is there a better way of doing this other than with the advanced filter?

Thank you
Mark