|Do you already have the 31 sheets created and you just need the Names changed?|
Do you want the Month name on each tab or just the number (which is all that you asked for)?
There are not 31 days in every month. How do you plan to deal with that?
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.