Sum sheet1:sheet30 and show running total for each sheet.

My formula is this:

=Sum(01April:30April!P15)

I need a formula that will show a running total for each day (sheet). As it is now sheet1 through sheet22 have the same total.

I would appreciate any help.

Is this what you are looking for (see encl. picture)?
=INDIRECT("'"&A4&B2&"'!A1") --> =INDIRECT(" '01April'!A1 ")
A4: 01
B2: April

Ola Sandström