Merging Two Worksheets

I have two worksheets in the same workbook that need to be merged into a third worksheet. I need to take all the data in worksheet "On Hand" and bring in from the worksheet "Transactions" the data in columns E & F (into the new worksheet "Excess Inventory"). There will be item numbers (Column B in both sheets) that will only be in the "On Hand" sheet.

I have entered data in the sheet "Excess Inventory" to show what I am trying to do.

Thank you!