I am trying to insert data into a worksheet based on users input. I
want to get an input TodaysDate get its value and insert the data that
they put into the form into that worksheet which is named the same as
the Date. I have a workbook with 31 sheets for the corresponding 31
days in December and they will input the date on the form and I want it
to go to the worksheet with the same date. Here is my idea in code but
I need help making it work.

TodaysDate = Insertdata.Range("D2").Value
newwrksheet.Name = TodaysDate