I have a spreadsheet which lists work assignments:

A B
C D
Name Primary Assignment Secondary Assignment Tertiary
Assignment

I have also built a summary sheet which has a box for each assignment
type. I want every person's name who is assigned to a specific box to
automatically pull in when the first sheet (above) is updated.

A B
C D E
Assignment A Assignment B Assignment C Assignment D
Assignement E

Want names to pull in here. Name might appear in multiple columns or
just one.

Any thought on how to accomplish this. I don't think a vlookup would
work in this case.