Looking for an automation expert to streamline my monthly reporting process. I have multiple data sheets (recurring reports) saved on a drive that need to be aggregated, cleaned, and visualized. The Workflow: Data Collection: Automatically fetch data from multiple source files (Excel or Google Sheets) stored in a specific folder. Quality Checkpoints (Crucial): Before syncing to the master sheet, the tool must run "Quality Gates" to identify faulty data. This includes: Identifying missing values or empty rows. Flagging data that doesn't match expected formats (e.g., text in a date column). Checking for duplicates or anomalies. Master Sync: Clean data should sync into a Master Google Sheet. Summary Dashboard: Create a high-level, visual dashboard (using a Pivot-style view or Looker Studio) that summarizes the information received for that month.Deliverables: An automated script or workflow that I can trigger monthly (or scheduled). An "Error Report" or log showing which rows failed the quality check. A clean, visual dashboard showing key KPIs and summaries.