I already collect vehicle-revenue figures in a well-structured Google Sheet; what I need now is a self-updating workspace that turns those numbers into a clear weekly snapshot of Total Revenue. Here is what I’m after: • A dynamic “Weekly Summary” tab that rolls up the latest seven days automatically—no manual copying, pasting, or date filtering. • Behind-the-scenes formulas, array logic, or Apps Script triggers (whichever you deem best) that refresh first thing every Monday. • A compact dashboard view of the headline Total Revenue, supported by a simple trend chart so I can see movement at a glance. • Clean, well-labeled ranges and comments so the file stays scalable; I will likely add revenue-by-vehicle-type and growth metrics later. Acceptance will be based on three points: the summary updates itself after I drop in fresh data, totals reconcile perfectly with the raw sheet, and your logic is easy for me to audit. Clear English communication is essential because this sheet will be a core, ongoing asset.