Use formulas in the subsequent sheets refering to the 1st sheet.

For example to get Sheet A1 value in Sheet A2
enter the formula in Sheet2 A2
=Sheet1!A1

If this post helps click Yes
---------------
Jacob Skaria


"shellyjohnson" wrote:

I have 5 forms (all formatted differently) that need to be filled out for
each transaction. They all contain the same information. I would like to
fill out the first sheet and it automatically fill in the subsequent sheets.

Tired of forms!