Sure, open a new workbook, click on the first sheet tab, shift click on the
third one and choose InsertWorksheet from the menu bar, now you have six,
shift click on the last one again, and InsertWorksheet again, and now you
have twelve... You can probably figure out how to get to 30 or 31 from
here... :-)
To rename them, double click the tab, or right click and choose rename.

If all of them are going to have the same layout and format, read up on
grouping to Edit data on multiple worksheets so you can do them all at the
same time.

"David T" wrote:

Is there any way I can create a new tab for every day of the month and name
that tab whatever the day of the month it is...ie Tab 1 will be named "1"
(for day 1) and Tab 2 will be name "2" (for day 2) and so on and so forth.