[SOLVED] Create button to save cell data to workbook header

Hi,

I am trying to create a button that when clicked will save the data from a cell into the center section of the header for all sheets in a workbook. The cell will contain a customer name and that is what I need in the header to be printed out with every sheet within a workbook.

Any help would be appreciated.

Thanks

Tony