How would I go about creating a Macro/Script that would pull from 3 different workbooks?

[OutRightWar]

How would I go about creating a Macro/Script that would pull from 3 different workbooks?
So, I would enter a phone number, then auto-populate the rest.

For instance, If I put in a phone number in A2, then it would pull the number and a certain_ID from one workbook, and pull separate info from workbook 2 and 3 and populate into one row on the main spreadsheet.

Thank you in advance,