Combining Multiple Spreadsheets (semi-duplicates)

Hi all,

I know it's been posted before but I can't seem to get my head around it, so I thought I'd start a new thread and show my working example file.

I have 3 worksheets in one .xls file and they are lists of restaurants. They have been scraped from different sources but there's approx 70% overlap. Problem is, from one source the relevant data might
a.) be slightly different from the other sources (so I need to define which is the default)
b.) one source might have more information (extra columns) than the other sources (perhaps including the default source).

How do I merge them?

I've attached a sample of what the working excel file looks like, and a sample of the outcome.
Assume the first worksheet is the default (if overlap, choose Data Capture 1 as right), then Data Capture 2, and lastly 3.

Hope you guys can help!