For work I need to create a workbook to use to calculate different stores sales numbers per week as well as adding each week to the monthly list. I have tried a basic sum(sheet1:sheet4!c3) for the monthly sheet but this does not work for my situation because i also need to be able to organise them highest to lowest for presentations each week to see how each store is tracking. and due to the formula being cell specific any time i try to organise the weekly tables in their descending order it throws out the monthly reading. How would i go about changing the monthly formula to better calculate by each stores results and what grouping or any other changes would i need to do to my weekly sheets so this can work without being too overly complicated so i can pass this on to other managers who may not be AS handy with excel as i am.