How do I stop building reports by hand every week?

Identify the source systems behind the report and connect them to a repeatable reporting process. Standardize the calculations, refresh schedule, and definitions so the same numbers are produced the same way each time. Keep manual review for exceptions, not for rebuilding the whole report.