Just use the following formula:

=Sheet1!A1

This pulls the contents from cell A1 on worksheet "Sheet1".

You could also type = in a cell, then move to the desired worksheet and
click on the cell you want to reference. Then hit Enter.

HTH,
Elkar


"TonyB" wrote:

I have a workbook set up with several sheets that have repetive information
in different cells of each sheet. Is there any way to autopopulate from the
one cell?