Automatic date in following sheets

[wavemehello]

Hi there,
I have a week in sheet1. For eg.
01/07/07 in A1, 02/07/07 in B1 ....... 07/07/07 in G1.
Now in sheet2 I want to continue 08/07/07 in A1 ..... 14/07/07 in G1
and so on and so forth in following worksheets.
How can I automatically obtain the dates in corresponding columns in the following worksheets?

Thank you

 

[wavemehello]

Oh, now its getting complex, I dont understand a thing, unless someone wishes to explain me what that piece of codes does

 

[Stormseed]

Copy the code which Mr. Jindon provided to you under the "Worksheet_Change" event in the Visual Basic Editor.

Double click on Sheet1 in the project explorer in the VB Editor, on the right hand side pane you have 2 dropdowns. Select "Worksheet" in the first dropdown and then select "SelectionChange" in the second dropdown and paste that code in the white area in between "Private Sub Worksheet_SelectionChange(ByVal Target As Range)" and "End Sub".

I hope you are clear !