Can someone give me the whole code on how to make a sheet that I am currently on to get automatically renamed when I put something in A1, & then when I am on my next sheet & I type something in A1 again, I want it to do the same thing, & so on.

The name that will go into the cells will be as dates, problem is the date formula has slashes & that doesn't register well with the sheet name, so I was wondering if it can grab the dashes that I type in the cell instead like 1-15-2000.

& last but not least lol I was wondering if I can get the code with the error, check, message thingy, u know where if u put a slash, or more than 31 characters, etc., it will tell u there's an error, and u click ok, etc. :-) Thank uuu

O & where do I put this code @? :-)