Macro needed to create custom/dynamic header

[astohl]

I know that this request is something that has been touched on before here, but in looking at past threads, I wasn't able to find a solution to my problem.

Please see attached sheet. I have a workbook with multiple worksheets that are driven by one main input page. I would like to have the header of the various pages to reference a specific cell in the input page, and automatically update every time I change that cell's information. For example, I would like the text in cell C3 of "Input Page" (in this case "ABC Co") to be the centered header of Page1 and Page 2.

It's my belief that there is a simple solution to this, but I just can't figure it out. Any assistance would be greatly appreciated.