I have a central data sheet. It has a cell with =TODAY() in it, so it
changes with the months, and shifts lit cells around according to dates and
workdays. Is there a way to not only save this dynamic data sheet at the end
of each day in its current state, but to archive this data to another master
sheet as well, so that data is not lost when the month changes?

For instance, I only need to save data in column A, C, and G to a range
designated for January on a master sheet in the same workbook. When =TODAY()
switches to February, I'd like to automatically archive a new month of data
on the same master sheet in another designated range.

Is this possible? And is it possible to automatically clear that dynamic
sheet upon the advent of the new month?

Thanks for all your help, people.

Arlen