I have 3 lists of names. Each list is populated by a very similar though not identical subset of names. In each list, every name has a ranking.

I would like to create a sheet that contains each name listed only once, along with all 3 of it's corresponding rankings(with the rankings appearing to the right of the name).

I would want to be able to periodically update the source of the 3 rankings which would then update the new sheet. Ideally I could arbitrarily scatter the names on the new sheet and have the rankings follow the name.

Any suggestions? Thanks in advance for the help!