Excel 2011 for Mac - command to create new form and name sheet according to date entered

[scheermadness]

I'm trying to create a very user friendly form for a team of mental health workers, who are not tech savvy.
Essentially, it's a progress note that is filled out after each session. I'd like for the template to carry over to the next sheet and be named the date of session that the therapist enters in a particular cell.
Rather than copying and pasting the form on multiple sheets, I'd like the user to be able to hit a button that brings up a new sheet, which will be automatically named "mm-dd-yy" as soon as she enters that information (which will hopefully be via a date picker.)

As each session gets its own note (and sheet), I'd also like to have the "Session #" cell be automatically populated - sequentially.

I mentioned that the therapists are not tech savvy, but I am not an expert by any means, so I struggle with understanding code writing.

I'm using Excel 2011 for Mac.

Please help. You're my only hope, Obi Wan.

 

[scheermadness]

I also wanted to add that I believe I will be using a "User Form" instead of a template.