Well, I think I'd start by getting all the data into one workbook. With both
workbooks open, select the worksheet with the phone number and address then
click EditMove or Copy Sheet. Select the target book under 'To Book' and
select it's required destination under 'Before Sheet' Check the 'Create a
copy' checkbox then click OK

Once the data is all in one place you can copy the require columns to where
ever you want them