|I'm not sure what you are trying to do.|
I don't know how you are trying to reference the sheet nor do I know what you mean when you say *today's date*. I don't know the format, I don't know how the sheet name was created, etc.
Keep in mind that we can't see your workbook from where we're sitting, so you need to be very specific in the explanation of what you doing and what you are trying to do.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.