I usually take my Excel spreadsheets into Access to perform this task, then
bring them back to Excel. It would save me some time if it can be done in
Excel.

I have two tables. Table A has 5 columns & table B has 3. Both tables
contain a column with similiar info. I want to make a new table that contains
all columns from both tables. Following is an example of what I'm trying to
do. I am not actually dealing with this type of data, but thought it would be
easier to explain using this scenario.

Table A: Name, Address, DOB, SS#
Table B: Name, Child's Name, Phone#
New Table: Name, Address, DOB, SS#, Name, Status, Phone#
(FYI - the new table should contain every record from Table A, but only
those records from Table B where the "Names" match.)