Auto fill consecutive dates across worksheets

[unrefined]

Forgive me, programming was never my forte. Neither was explaining things.

I plan to have 52 worksheets in this workbook with 7 cells (C10-I10) in a row listing the dates. Each subsequent sheet would have these rows listing the subsequent dates!

For example, Sheet0 cell C10-I10 would be 1/1/2006, 1/2/2006, 1/3/2006, 1/4/2006, 1/5/2006, 1/6/2006, 1/7/2006

Then on Sheet1, cell C10-I10 would be 1/8/2006, 1/9/2006, 1/10/2006, 1/11/2006, 1/12/2006, 1/13/2006, 1/14/2006 and so on across all the sheets.

K6 and M6 would ideally follow a similar pattern on each sheet as well but it is not entirely necessary.

Thank you in advance for reading this. Workbook is attached.

Edit:
Is there a VBA code for this?

[davesexcel]

Maybe a simple loop,

Please Login or Register  to view this content.

[sktneer]

You may try something like this....

Please Login or Register  to view this content.

[vichopalacios]

If you don't want to create manually all 52 pages, you can start with your book having only sheet 0 and run the following.
I've just modified a bit @ davesexcel 's code

Please Login or Register  to view this content.

[unrefined]

Oh my gosh! Thank you all so much, this is exactly what I needed! I've been looking for something similar to this all day you are life savers.

[sktneer]

You're welcome. Glad we could help.
Thanks for the feedback.