|The BeforePrint event can be used to check a specific cell and create the footer immediately before printing.|
Code similar to this would be placed in the ThisWorkbook module of the VBA editor.
Private Sub Workbook_BeforePrint(Cancel As Boolean)
Dim WS As Worksheet
For Each WS In Worksheets
WS.PageSetup.LeftFooter = ThisWorkbook.FullName & " " & _