Want to dump text written on page 1 to page 2 in excel

[Moni]

Need to dump certain text from sheet 1 to sheet 2

 

[Gary]

is the text written in a cell?

 

[Moni]

Yes it is.

is the text written in a cell?

 

[Gary]

if the text is in the cell A! of Sheet1. in Sheet2 type, =Sheet1!A1.