Just link the other headers

=[Book2]Sheet1!$A$1

Regards,

Peo Sjoblom

"DaleM" wrote:

Hi I am working on a spreadsheet that has a header at the top of each
document, that includes Name, date, materials etc. I want the info that I
type into the top header to always go to the other headers. Copying and
pasting is too time consuming as there are numerous pages. How can i do this?