I have no idea if I can make this make sense to anyone but me, so please bear with me.

I'm completely new to VBA and mostly trying to figure out if this is possible before I start looking for ways to do it. I'm not sure how flexible VBA is.

Basically, I have a bank deposit workbook that I fill in every few days, and I'm trying to make it as easy as possible for my lazy fingers and anyone who happens to fill in for me. It's basically one sheet with a summary, and a separate sheet for each day for a breakdown of where money is coming in from, so the number of worksheets varies with each deposit and can be anywhere from two to ten+.

What I'd like to do is add a new sheet at the beginning of the template that will look something like this:
\1

Then I just fill in relevant data and it creates the number of sheets needed (one for each day in the day range) and names them consecutively (so in this case, it would create three sheets named 1, 2 and 3) as well as change the date on the sheets (So the dates would be 1 Jan 2013, etc). Petty Cash and Deposit are both on the summary, so they aren't actually important and we're going to ignore that bit.

I'm mostly just trying to make it so I don't have to manually copy sheets a bunch of times and change their dates, but I'm not entirely sure if it's possible to do any of this with VBA, and I know if I can't and I try I'm just going to get frustrated.