I have multiple worksheets, in column A I have a unique identifier & in
column b I have # tied to that identifier that is different in each
worksheet. What I would like to would be to display in a new worksheet all
the identifiers (combine where they identifiers match in each work sheet) and
display in columns all the #.

Example: in worksheet 1 I have ID - #1
1234 - 5
2345 - 7
3456 - 8

In worksheet 2 I have ID - #2
1234 - 6
2345 - 10

In the new worksheet I would like to see: ID - #1 - #2
1234 - 5 - 6
2345 - 7 - 10
3456 - 8 - 0

This would be easy to do in SQL, but I haven't the slightest idea how to do
in excel
Thanks