I need my master sales tracker in Google Sheets to mirror the daily results that are captured in a separate source Sheet. Right now the figures drift out of sync, so I want an immediate clean-up and a sustainable way to keep them aligned. Scope of work • Pull in every new daily sales entry from the source Sheet. • Detect and overwrite any existing rows whose data has changed. • Locate and delete rows in the master file that no longer exist in the source. How you achieve this is up to you—IMPORTRANGE, ARRAYFORMULA, Google Apps Script, or another approach—as long as the final sheet always reflects the current state of the source without manual intervention. Deliverables 1. An updated master Sheet showing 100 % accurate daily sales data. 2. The working formulas or script placed inside the Sheet. 3. A brief note explaining how the sync works so I can maintain it. I’m ready to grant access and move quickly; please only respond if you can start right away and turn this around fast.