Is there a way to change the date on the header on one workbook and it
automatically changes the date of a header on multiple workbooks within a
folder?

I have a folder with various workbooks and I want to be able to change the
date on the header for one workbook and it automatically changes the date of
the header on the other workbooks in the folder (i.e. - I change the header
date from January 2006 to January 2007 in one workbook; I want all the others
to change to January 2007 automatically).

Thanks in advance!

Rhonda Randolph
Medical University of South Carolina