new day in next worksheet Day 1 plus 1?

[Guest]

add the value to a date in 1st worksheet to the value in the date in the new
work sheet.
using a macro function
I would like to add a new worksheet and use the date value in the previous
sheet with an increment of 1.
So make worksheet with sunday jan 1 in cell a1 and add a new worksheet so
monday jan 2 is in cell a1 wksht 2.

make newsheet (lastsheet(a1)+1) ???????

 

[Guest]

Sub bumpit()
Sheets("Sheet2").Range("A1").Value = Sheets("Sheet1").Range("A1").Value + 1
End Sub