Is there a unique indentifier for each row?

If so, the quickest and easiest way is to copy and paste both into one worksheet, one after the other, Select All, then:

- Data
- Filter
- Advanced Filter
- OK if it gives an error
- Criteria range - select just the unique identifier field
- Tick 'Unique records only'
- Ok
- Select all, copy and paste into new sheet, then you have your merged sheets.

HTH
Chris