Need some help with the following:

I've got two worksheets that are exports of two separate reports. The first
worksheet has 6 columns of data that I need to append to the data in the
second worksheet. If possible, it would be great to have the merged records
written out to a third worksheet. Additionally, I need to match the records
in sheet 1 with the records in sheet 2 by a text field (Project Name).

Is there a relatively easy way to do this in Excel?