I am recording my Weekly Sales on a single worksheet and naming the sheet with the date of the first day of each week (eg 240105). The total daily sales are made up from three types of sale and are in the same range on each sheet (eg B6:B8).

I now want to calculate my average daily sales from a range of worksheets. Can anyone help me create a way of devising a formula where I do not have to enter the worksheet name and cell range 52 times such as this (=+AVERAGE('030105'!B6:B8,'100105'!B6:B8)) ?!!

I need the shortcut as I want to show average sales for each day of week for monthly periods with comparison to previous year which will be a huge amount of work. Any help appreciated.

Gary Williamson