VBA or a manual copy and paste. The only other solution is to put formulas in sheet2

in A1 type =Sheet1!A1 and then manually copy down fifty rows. I don't see that this is any easier than a manual copy and paste.

For my own curiosity, why don't you want to use VBA?