Merge/Join 2 Worksheet Data on Single Column

I need help automating a weekly process by creating a VBA macro. The process calls for merging the data of two worksheets into one NEW worksheet based on values in a single column. The two worksheets will have a varying number of tuples for every run, but the data format/layout will be the same. There are a few conditions: records/tuples must match on a single shared column (CODE in the example). If there is no match, the tuple will be included in the new sheet without any matching data to fill up the remaining columns. That would be the easiest way to spot the records that did not have a match.

The data layout is below:

WORKSHEET 1
[Name] [Code]

WORKSHEET 2
[Time] [Code] [Amount]

NOTE: Shared column is CODE.


The real data has been simplified to these few columns to easily express the concept. Actual data is around 25 columns. Attached is a tab delimited example data file (forum_exampleData.txt).

Thanks in advance for any contribution!
Mary