When you're creating a custom header or footer in Excel, you can enter the
page numbers, tab names, file names, dates and all manner of other
automatically calculated data. Sometimes, however, you want to set up your
headers so that the header includes a snippet of information that is on the
worksheet somewhere. It would be great if you could specify a cell reference
on the current worksheet in a custom header or footer for that worksheet.