--Insert a dummy sheet as the last sheet and name it 'last'
--In the total sheet apply this formula.
If the first sheet is named as 1
=SUM('1:Last'!M10)

If this post helps click Yes
---------------
Jacob Skaria


"jtfalk" wrote:

I have a workbook that is going to have a new worksheet put in everyday. it
is a copy from a master that will be named for that days date.

I need to get the sum of all M10s from all of the worksheets to the "Total"
worksheet. Today there are only 10 worksheets but by the end of the year
there will be 30.

Thanks