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

But this would then require a slightly more comprehensive understanding of excel to create the pivot tables each day/week would it not? the results we will be tracking need to be able to be updated daily and while i am getting a better understanding of pivot tables with all the tutorials i have watched there will be some people in the company who could not do this on a regular basis. I am designing this to be super quick and as easy as possible, but unfortunetly that means more work to start with. But thanks

The alternative is formulas, which I believe are more difficult to maintain, ie. they break without constant maintenance.