List/Data/Summary question

Goal is to have a summary sheet of which vendors were chosen throughout a purchasing project.   Sheet 1 is a matrix of all items to be purchased, listed by vendor (pulling from a linked master shee...