Otto Moehrbach said:

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.