How do I autopopulate data in excel?

[Guest]

I am creating a workbook that has 20 worksheets in it. I need some cell data
from the first worksheet to auto-populate in various cells on the other
worksheets. Is this possible?

 

[Frank Kabel]

Hi
use a formula such as
='sheet1'!A1

 

[Guest]

hi,
yes. you could use something like
=sheet1!cellAddress