synchronizing mutiple sheets to mirror the previous data
 

Imagine having a workbook with 31 worksheets representing the days of a month. "Day 1's" data sets the standard/format for "Day 2's" data, and "Day 2's" data sets the standard/format for "Day 3's" data.... and so on.

If I make a change to one particular day, I need all proceeding days or sheets to change / mirror the sheet being edited. It is important that the previous sheet's data remains unchanged.

To make things a little more tough, some of the data on the sheets are color coded with the fill tool. This will be changed periodically but must be mirrored to the sheet being edited too and carry over to the upcomming days.

Please help me! How can this be done?

Thanks!

Rick :-)