"Otto Moehrbach" wrote...
Say your data in worksheet 1 starts in A2. *In worksheet 2, cell A2, enter
an equal sign. *Then select worksheet 1 and click on cell A2. *Hit Enter.
In worksheet 2, select A2 and drag that formula down with the fill handle as
far as you need to. *Repeat all this for column B. *There are other ways if,
for some reason, you don't want the above.
....

Picky: inserting or deleting rows in either worksheet could alter
this. Row DELETION could be handled by making the Sheet2 formulas

Sheet2!A2: =INDEX(Sheet1!$A:$A,ROW())

Sheet2!B2: =INDEX(Sheet1!$B:$B,ROW())

And if column deletion could also be an issue,

Sheet2!A2: =INDEX(Sheet1!$1:$65536,ROW(),COLUMN())

would always refer to the corresponding cell in Sheet1.

Only event handlers could deal with row/column INSERTION in which case
new formulas for newly blank cells would be needed.