Need help merging data from 3 worksheets into 1

Is it possible to merge data from multiple worksheets into 1 using key cells that identifies the data ? Example:

Worksheet 1.....................................Worksheet 2

Column A............Column B...............Column A................Column B

Joe......................Smith.....................132452....................Doe
Jane....................Doe........................655468....................Smith

I would like to merge the data from both worksheets into 1 using the key cell that ties the data from each worksheet (in this case, the last name) so that it displays as follows:

Column A............Column B.............Column C

Joe......................Smith...................655468
Jane....................Doe......................132452

I hope this makes sense..... I guess it would be like joing two tables using a Key identifier for each table like you would in SQL ???