"swatsp0p" wrote in
message

You don't give us a lot of information to go on. Such as <where on the
other sheets you want the information. How many cells on the original
sheet need to be replicated, etc.

If it goes in the same cell on each sheet and there are only a few
cells to replicate, simply select the desired sheets (hold down CTRL
while clicking on desired sheet tabs) then enter a formula in the
desired cell(s) such as:

=Sheet1!A1 etc.

Now what ever is entered on sheet 1 in cell A1 will appear in the each
of the sheets in the cells with the formula.

OK thanks for the input. What I did mean is that on one quite complicated
worksheet, the value entered is to be duplicated across other worksheets but
in different cell positions, sometimes multiple.

E.g. Maybe the first worksheet is Invoice and another worksheet is invoice
breakdown.
Where the invoice number is entered on the first worksheet, this is
replicated for each part number for the invoice related to that number.

OK probably not the best example actually, but I'm trying to demonstrate the
fact that the field on the first worksheet can be copied to many different
multiple cell locations on other worksheets and automatically updated if
there is a change.

But from the information you have given my I have been able to work it out.
All I do is simply enter the sheet number and cell number as formula of
where I want the information to come from. (e.g. =SheetInvoice!C1) Easy! At
least it seems easy so far.

Any more hints or tips that will help me with this then please let me know.

Cheers

David.