While we are at it......if I change the number on sheet one will it
automatically update the rest of the sheets?

"Pete_UK" wrote:

You can put this formula in A1 of Sheet2:

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

and then you can copy it across and down to suit your requirements.
You can do the same for the other 3 sheets. It will not copy the
formatting, though (you can't do that with a formula).

Hope this helps.

Pete



On Sep 21, 1:22 am, bigonlif
wrote:
How do I input data on one worksheet and have it appear on the next four
sheets? Copy and Paste is tricky between sheets and forgets itself if I
dawdle. Is there a way to do that instead of re-entering all of it again?