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 Cell E7 on the monthly totals should equal ='01'!E7+'02'!E7+'03'!E7.......'31'!E7

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

Thanks in advance
Neil