You can reference information on another page. As an example the formula

=Sheet1!A1

is on sheet2 and references the value in sheet1 A1

Lance
"Dan" wrote:

i have work on 3 different sheets in the same workbook, the first page
contains information that I would like to automatically fall into certain
cells on the 2 & 3 sheet, how can this be done.