Script for Google Sheet Data Aggregation

Ava's Construction has hundreds of google sheets that list contractors with their point of contact and contact information. we want to aggregate these into a master sheet, removing duplicates. We would be adding a geographic "Market" to each contractor entry which does not exist now.

The attached excel file - the "QP" tab is a good example.

We would be aggregating contact info only.

We are interested only in using AppScript to created an automated way for the existing set of sheets and also future sheets that will be made