I have 2 worksheets (2 individual XLS files) that I need to bring together
into a single worksheet.

The first column of each spreadsheet is the "persons" ID number.

I want to append the in worksheet 1 with the data in worksheet 2, based upon
the ID number. The data in worksheet 2 is a mix of text, number, phone
number, etc.

Is there a single formula I can use to bring it all in based upon the ID
numbers in column A?

eg.

WS1 WS2
123|Mark 157|trans|(201)646|2008 Event|Yes
124|Harry 123|mortg|(732)995|2008 Event|No
129|Dave 762|rund|(676)423|2007 Event|Maybe
129|mortg|(212)123|2008 - Trip|Yes
124|party|(919)222|2006 - Trip|No

DESIRED RESULT IN WS1
123|Mark|mortg|(732)995|2008 Event|No
124|Harry|party|(919)222|2006 - Trip|No
129|Dave |mortg|(212)123|2008 - Trip|Yes