I have a monthly report setup to make my job as easy as possible. The workbook is great and provides maximum output for minimal input, with one darn exception! I have to update the footer each month on 10+ sheets. I have one cell that I enter the date each month, and other cells use this as a reference point. Example: The input cell format is dd/mm/yyyy, and I use the formula &TEXT(Summary!E4, "MMMM YYYY") to display the full month and year on the cover page within text.

I want to do the same for the footer, however, I know headers/footers don't act the same as cells. Does anyone know how I can have this automatically update based on that reference cell?

Thank you in advance!