Sheet names would be manually set, or controlled by some VB code, I believe those are your only two options to do what you've asked.
BUT, maybe you're coming at this from the wrong end. You could make your Tally Sheet use an INDIRECT reference to refer to sheets that haven't been created yet. As long as your users DO name their sheets properly (a training issue), the tally sheet would work properly. Plus, the tally would serve as a sample of what the dates SHOULD look like.
On the tally sheet, create a reference column with your desired sheetnames
Now, to the right in the same row, you put in INDIRECT references to cells. So, let's say the first thing you want from the sheet 12/1 is the answer in cell B10. The next formula in the row with 12/1 would be:
That formula is constructing the reference from dates in column A. Pretty cool. If a sheet hasn't been created yet by a user to make the INDIRECT call complete, it just returns A ZERO VALUE. When the user creates the sheet and starts filling it in, the tally starts working on its own.
Bookmarks