I'll try to explain things a little better, but it looks as if the filter
idea may work. It's something I haven't tried yet, anyway.

The Flags for Patriotism Program is a project for a social organization in
which members of the organization post American Flags at participating
businesses on specific holidays of the year, and a few extras now and then,
for $50 per year.

The project is divided into 6 different routes around town, posting a total
of 120 Flags around town. The tabs for the six different routes are labeled A
thru F. There is a "Summary" tab at the end that will print out the pertinent
information needed for the paperwork for the project.

The tabs for the routes are identical with the exception of the business
names and addresses. The names of the people that posted the Flags for a
particular route are in A4, K4, A5, and K5. [We've never had 24 people help
at one time before, but there's room for it should it ever happen.] Each
vehicle that is involved with the project is given a vehicle number (1-6).
[We've also never had 6 cars before, but there is room for it should it ever
happen.]

The information would look like this:

Tab A - Cell A4 = W.A. - Cell K4 = C.C.
Tab A - Cell A4 = Blank - Cell K5 = Blank

Tab B - Cell A4 = W.A. - Cell K4 = C.C.
Tab B - Cell A4 = Blank - Cell K5 = Blank

Tab C - Cell A4 = R.H. - Cell K4 = M.C.
Tab C - Cell A4 = Blank - Cell K5 = Blank

Tab D - Cell A4 = R.H. - Cell K4 = M.C.
Tab D - Cell A4 = Blank - Cell K5 = Blank

Tab E - Cell A4 = L.C. - Cell K4 = T.F.
Tab E - Cell A4 = Blank - Cell K5 = Blank

Tab F - Cell A4 = L.C. - Cell K4 = T.F.
Tab F - Cell A4 = Blank - Cell K5 = Blank

In this example, there are 3 vehicles, each with 2 people, totaling 6
people. Using numbers and comparing NUMBER of people in each car with a
vehicle number, I can make the numerical version work exactly how I need it
to through a series of 'count' and 'if/then' statements comparing vehicle
numbers, etc. However, using the same method does not work with the TEXT of a
person's name. Everthing I've tried lists each name twice (because they each
did two routes), for a total of 12 names listed.

On the "Summary" tab, the information [people's names] would be gathered in
cells A44:F48.

Any help you would be able to give is appreciated. Thank you, in advance.