UNION VBA

I have 2 worksheets which I would like to UNION on excel but do not know how.

Sheet1: Call Schedule - Contains list of customer which I plan to visit - contains 77 recordds
Sheet2: Call Extract - Contains list of customer calls which have been executed - may be executed with the customers in "Sheet 1: Call Schedule" or could be with new customers which did not exist in call schedule. contains 105 Records

What I am trying to do is to combine the 2 files to show
1) the 105 records in "Call Extract"
2) Customers in "Call Schedule" which have not been executed and hence does not exist on "Call Extract" - created 4 dummy records for this
3) In total the UNION file should have 109 records.

I had this work with an SQL query - by using a LEFT JOIN -- UNION -- RIGHT JOIN

Can I replicate this in excel?

AttachmentSize
MergeTest2.xlsx15.07 KB