Okay, a spreadsheet with two tabs. Let's say tab one has | UID | DOB | NOSE
SIZE | (for example), tab 2 has |UID| No of Ears | Nose hair |

I would like to take duplicates where UID is the same out of tabs 1 and 2
and put into a new tab with | UID | DOB | No of ears | Nose hair | so third
tab has all people from tab one and two which exist in both and a cross
section of information from tab 1 and 2.

Have I confused anyone?!?

Thank you all because you're bound to be much cleverer than I is.