On your other worksheets, enter the formula =Sheet1!A1 (changing the sheet
name and cell reference to match your needs). In this example, any data
entered into cell A1 on Sheet1 will automatically populate to the other
worksheets that reference that cell.
--
Elisabeth


"DouglasGrantPhD" wrote:

I have created several sheets that I use as different forms, one is a billing
sheet, and one is a data summary sheet. I need this information to remain in
a patient's file and I am constantly changing the headers to include the
patient's name and medical record number. Is there a way that I can type
this information once somewhere, then have it placed on every sheet within a
workbook?