Hi,

I have a monthly workbook which consists of a worksheet for each day. These sheets are named 01, 02, 03 etc up to 31.

I also have a monthly totals worksheet. I want to sum certain cells on each sheet to show in the monthly sheet....

eg ='01'!E7+'02'!E7+'03'!E7.......

Is there a quick way of creating this formula without manually typing it in?

Thanks in advance
Neil