I want to populate all six locations of the header and footer in all sheets within a workbook with standard items when creating workbooks. For example,

LeftHeader= Company name
CenterHeader= content of cell A1
RightHeader= "Printed "& current date

LeftFooter= filename + worksheet name
CenterFooter= Department name
RightFooter= Last modified date

I'm thinking this could be a macro applied when opening the new workbook, but the items within the workbook should update immediately when changed.

How best to do this?