I need a dynamic Google Sheets dashboard that turns raw sales data into clear, auto-updating visuals. The sheet already holds the numbers; what’s missing is the logic and design that will let anyone open the file and instantly understand how sales are performing. Here’s what the finished file should do: • Pull new sales entries into a clean, consolidated table without manual copy-pasting (QUERY, IMPORTRANGE or Apps Script—whatever keeps it reliable). • Generate live charts—bar, line or pie—so I can view revenue trends, spot best-selling items, and compare results across regions if we add that slice later. • Refresh automatically on open or on a timed trigger, with formulas and scripts protected against accidental edits. • Present everything on a single, well-branded dashboard tab that looks good when shared or printed to PDF. Delivery is ASAP, so I’d like a quick kickoff call, a first draft I can review in real time, and a final hand-over that includes brief, inline documentation of any custom script. If you’re comfortable blending Google Sheets functions with Apps Script to make visuals pop and data flow on its own, let’s get started.