Ok now I have got that to work but it still populates each sheet with the same 7 dates

in my original code it populated each sheet with a with 7 dates each sheet dates 1 week ahead of the previous sheets starting date

hope I'm explaining myself correctly