Need to set up a workbook that copies text from various worksheets in the
workbook into a summary page at the beginning of the workbook. Cannot figure
out the forula to copy one cell of text to another cell automatically -
Please help!!!

hi,
formulas return a value, they cannot perform an action
like copy.
you can have formulas on your summary page that return
values from other parts of your work book.
something like
=sheet1!A1
this formula anywhere on your summary page will return
what ever value is in cell A1 on sheet 2.

-----Original Message-----
Need to set up a workbook that copies text from various
worksheets in the
workbook into a summary page at the beginning of the
workbook. Cannot figure
out the forula to copy one cell of text to another cell
automatically -
Please help!!!
.