If you run into a conditional header or footer request that you can't handle, take a look at Word fields. They're not magic, but it kind of feels like magic when they do what you want.

In addition, scores of readers e-mailed us about other Excel methods for including a file’s path and name in the body of the spreadsheet; while these processes are not automatic and may not put the ...

Excel headers and footers are a great place to display page numbers, titles, an author’s name, and so on. However, there is a limit to the number of characters the header or footer will accommodate.