I need to update a spreadsheet from 2 different workbooks with over 5000 lines

my work has been using excel as a primary database which has been problematic, I receive 3 separate "trackers" everyday with updated information. I would like to be able to keep ONE spreadsheet that I can update everyday with the new information applicable to my work. I have specific cell sites with tasks that must be completed before construction/maintenance can begin, I receive spreadsheets with updates for Utah, Idaho, and Colorado which has updates for these tasks, zoning, building permits, ect. Is it possible to extract only changes from each spreadsheet to one so that I don't have to manually go through 5000 different sites? V look up helps, but I don't know enough or if it's even capable of extracting only what I need? Please can someone help???

Jaie I've uploaded a sample spreadsheet with information I receive everyday I need to transfer to one primary spreadsheet, the uploaded one is the shorter one.