Almost Solved: Merge Two Worksheets Data while Filtering Help Please :)

Hi, I'm brand new to Excel.

I have two worksheets that I would like to merge.

The first sheet has about 200 hundred names and addresses.

The second sheet has about fifty names, each having a reference number next to them.

The fifty names are all included within the 200 names.

I'd like to send the addresses from the first sheet to the second sheet so that I have a spread sheet that shows Name/ Address/ Reference Number.

thanks for any help