lose of coherence due to insert rows

[Jorgefar]

hi , used excel 2010

i have 2 sheets in a book that contains tables.

the sheet 1 is the pincipal , there i introduce data so the second sheet takes the information from sheet 1 and aplies formulas then sheet 1 call that information back and show it in the table and use it to do more things . 

the problem is , when i insert a row in sheet 1 the info below moves but in sheet 2 it doesn't . It is important to have the rows "aligned" to keep coherence in formulas in sheet 1 . 

Q: Is it posible to make that when i insert rows in sheets1 the same happens in sheet 2 ? if that is not possible how can i upgrade the tables without draggin down all the formulas again?

[#2]

@Jorgefar 

How is that setup possible without problems? can you share your workbook?

[#3]

Hi.
I don't know the formula you are using. When you Vlookup to link sheets, this usually happens and is generally overcome by using Index & Match formulas.
You can still fix the cell/table references with the "$" sign in either of these formulas and you'll be good to go.
Kindly share the workbook (or a sample) for further assistance