Unlike a PivotTable, a Cube Formula Report can retrieve data from multiple sources. With a shared database such as Microsoft Analysis Services cubes, when you refresh your worksheet you and other users get the latest updates and it's all the same version of the truth. In addition, using Excel PivotTables and Excel Cube Functions, you can access Oracle® OLAP (using MDX Provider for Oracle OLAP from Simba Technologies) and Teradata® OLAP Connector
Power Pivot models can source data from many different Microsoft and non-Microsoft databases, including tables and ranges in the same workbook the models are created in. So with Excel 2010 - 2016 and Power Pivot you can generate Excel Cube Functions from an Excel range that you add to your Data Model; in desktop Excel 2013 and 2016, you can even do this without the Power Pivot add-in. This is so much easier and more robust than using the GetPivotData function which requires a visible PivotTable to reference. Plus, there is the potential to share this data in SharePoint or in Power BI if you upload and publish your Data Model,
Maintaining your reports (adding additional months or a new region) can be as simple as copying a row or column and changing the label or heading. To repeat, because cube functions are regular Excel functions you can leverage your existing skills and all of Excel's other functionality - no new products to learn or buy.