@ANazarian You might consider the HubSpot Integration for Power BI, which is available in the HubSpot App Marketplace. By using the integration to make your HubSpot data available in Microsoft Power BI, you can build the kind of reports you were asking about. An you will be able to create an automated data refresh schedule so that each time you open Power BI, the most recent HubSpot data is used to update your report.
If you are more accustomed to Excel, take a look at the Excel Integration for HubSpot. Using this app, your HubSpot data can be set up to refresh in Excel on a regularly scheduled basis.
Both apps have a free trial, so you can see what best fits your needs.