Month and Year in footer based on cell data

[ERI GURU]

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!

[mikeTRON]

In the past I also got annoyed with this and just Googled my way to success.

http://excel.tips.net/T002522_Puttin...n_Footers.html

You can create what you want in a specific cell then just have a macro automatically fire off