I really need help.

I have two worksheets with data in columns A-G. Column B has content like
"HDMU4524565". This is in column B of both worksheets. There are multiple
duplicates in Column B on both worksheets. I need to combine the two
worksheets keyed on column B and have no duplicates.

I also need to pull the data in the other columns over that corespond with
the entries in column B.

Example:

Column A Column B Column C Column D Column E Column F
Column G
Hunter HDMU454657 SMITH 7/5/05 8/5/05 8/5/05
YES

My boss is on me to do this report more efficiently.

Any help is appreciated.