See attached. The only real change to your workbook that's needed is to have a space between the month name & year on the 'July 2015' worksheet.

Note that there's now a bunch of formulae in row 11 on the 'MonthStats' sheet referencing the 'July 2015' worksheet's name for date calculation purposes. If you're going to have formulae referencing other sheets, you'll need to change those formulae to reference the other sheets or calculate the dates in some other way.

Once you have whatever you want for 'No Jurisdiction / Transferred' sorted out, I suggest you lock the 'MonthStats' sheet to prevent erroneous changes.

Attached Files

Demo.xls (54.5 KB, 10 views)

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]