Hello Friends,

Can you help me figure out with any formula of script that if I create a copy of existing sheet the data (dates, times etc.) contained in it will auto update in the next sheet created.

For example,

In the first sheet I have 5 cells with dates ( 1 jan, 2 jan, 3 jan, 4 jan, 5 jan), when I create a copy of same sheet I have to formulate (1 jan ) of sheet 2 to fetch last date of first sheet + 1 so that in sheet 2 the first date should be the subsequent to 5 jan that is it will 6 jan and than "1" is added to subsequent dates till the last date in the fifth cell is 10 jan.
kindly share your expert view/suggestion.

Your help will be highly appreciated.