Enter this formula in A1 of Sheet2:

=IF(Sheet1!A1="","",Sheet1!A1)

You can also put the same formula in Sheet3 and Sheet4. The formula
can be copied to any other cell to bring the appropriate data from
Sheet1 (but not any formatting you might have set up on Sheet1).

Hope this helps.

Pete

On Oct 12, 6:39 pm, KrazyAmg
wrote:
I am working in a book with differant sheets, most the the data is the same
on 3 sheets that I am working on. Can I set up a formula or action so that
the data I type in one sheet in one cell can auto populate into the other 3
sheets in certain cells?