Combine two tables

Hello, I need a macro written that will combine data found on two worksheets using an ID. In the example attached. Sheet1 and Sheet2 are the two tables to merge; the 'output' sheet is the expected result. Please note that the macro needs to accommodate Sheet1 and Sheet2 with undefined number of columns. In other word, in the example, Sheet1 has 2 columns and Sheet2 has 3 columns but the macro should still work is Sheet1 has 10 columns and Sheet3 8 columns for example.