Excel in the table with a different page on how to bring out a line of formula

Excel case of a boy with difficulty, you help errant.
In the same document excel, I would like to go to different pages of the line on the same page, at the same time out into a different page of the line is calculated through the formula And how to convert them?

You see it on the site, the video, a number of ways to solve your problems!
I do not write, if you do not understand, I add friends, we have to explore the assumption that the conversion of data to sheet1 of Line 1, wants to convert it to the A's sheet2 out, the A1 input sheet2 Formula
= offset (sheet1! $ A $ 1,, row (A1) -1)
A1 copy the formula down