Kpi's sheet that Auto counts from weeks to monthly but also sorts highest to lowest

In the example if you add a row to the bottom of the sales table or change any of the data in the table, then select anywhere in the pivot table and click Data -> Refresh.

You can automate the refreshing of the pivot table using VBA if you wish, so any change to your data is immediately reflected in the pivot table.