Increase value of cell with each new sheet

I was wondering if it was possible to increase the value of a cell each time a new sheet is created within a workbook. For example, I created a series of events with reoccurring dates (2nd through the 15th), on the next sheet I continued the dates (16th through the 29th). If another user creates a new sheet in the future can the copied sheet then continue the patter automatically (30th and on) without having to change the first date manually?
I would like to use this process for other functions as well such as number the pay periods and so on.
Thanks.

The following code will, when a new sheet is added, find the last value in column A of the previous sheet, add 1 to it and place this value in cell A1 of the new sheet.

Of course, it relies on macros being enabled when the new sheet is added.

Does this get you started?

Please Login or Register  to view this content.

I think it does, I will play with it to see if I can get it to work.
Thanks a ton.