Hi "Rose"

If the data format is the same on each sheet and you just want the total of
a cell in all sheets add a new sheet at the beginning of the book and another
at the end. Call them Start and End. Then on your Sumary sheet use the formula

=SUM(Start!A1:End!A1) and copy down and across.

If the data is different on each sheet have a look at DataConsolidation.
You can add the range in each sheet and produce a summary of all sheets. Be
careful to link the data so that it can be updated next month.

If the ranges are likely to change in future months you might like to add
blank rows and columns to the range when setting up your model.

Regards
Peter
"englishrose4719" wrote:

Ive got 31 x daily figures spreadsheets which i need to total up (daily) on a
Month End sheet. Is there a quick way to copy the formulas across instead of
having to rewrite it on all 31 worksheets? Ive not had much experience with
Excel but have got the formulas transferring from the Day 1 sheet to the
Month End sheet ok. Help in a non technical manner would be great please?!
thanks