example of what I want to do:
A B C D E
a a d a a
1 2 3 2 2
6 6 6 6 6
o p p c p
b g c c c

In my situation A, B, C, D are lists of the top 300 selling items, each list
represents a different location, and the E list is the list where all the
common values are sorted until E has the best choice for all the sheets. this
would represent a best fit for all the other lists.