Can I increase the length data from a formula in a cell?
 

I have two sheets. On Sheet2 I want A1 to record all data on Sheet1 A1.
I put in the formula on Sheet2 in cell A1 [=sheet1!A1].
My problem I found that Excell formula limits the amount of information I
can put onto Sheet1, A1 that will be copied to sheet2 A1.
Is there a way to increase the data in the formula or another to have the
same thing done with unlimited data copied from one sheet to the next?
--
John