I see that I can pull file names and sheet names to a sheet header. Is it possible to pull/link the data from a certain cell to the header instead?
This would be possible with VBA. For example, if cell A1 contains text that you would like to place as a header, then open up VBA, create a new module, and put the following:
ActiveSheet.PageSetup.CenterHeader = Range("A1").TextEnd Sub