If you want the same values in another sheet then go to the cell you want it
to be
Type =
Click on the source sheet and then the cell you want
press ENTER
Repeat for other cells or drag the formula
and you are done

"RMort" wrote:

I want to create a set of cells for address information where a customer can
fill in there address and it will automatically populate into the Header of
another worksheet in the same workbook. Is this possible?