Urgent Google Sheets Sales Update

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... (Budget: ₹1500 - ₹12500 INR, Jobs: Data Analysis, Data Management, Data Processing, Excel, Google Sheets, JavaScript, PHP)