Can Excel Link two tables on seperate sheets?
 

I'm using Excel 2007.
I have table1 on sheet1 and table2 on sheet2.
The first three columns of table2 are referencing the first three columns of
table1
using =+Sheet1!A1, =+Sheet1!B1 and =+Sheet1!C1 down to row 900.

If I insert a table row in sheet1 (say between rows 9 and 10) I'd like the
same thing to happen to sheet2.

Is this something that can only be done with code?