Copy data from multiple sheets to one main based on cell value

Here is the file modified to run when you open the workbook. Note that the macro was copied to the "ThisWorkbook" part of the VBEditor. and assing to the "OPEN" event.
The macro is still available to be run manually in the module.

Be advise that there are no test done on DUPLICATES. If you open this file each day and you do not erase the Sold cars in the various sheets, they will all be copied again into the Main sheet.
If you run this only once a month, then no problem.