AB33,
Sheet 1 as you said has 1 column with formula & when a row is added or deleted the formula shouldn't change (ie if I delete manually the sequence of the formula will change & I get an error, #). Sheet 2 is basically just a summary of sheet 1 & again if I delete the sequence changes & I get an error.

In short I want to insert or delete 1 row in both sheets without altering the squence of the formula.

Sheet 1 - Column A, there could be cells with 100,101,102 & column B, a,a,a. But if I wanted to enter another 100 (after the 1st 100) I would insert a row & enter 100 which would make 100 b in column A & B respectively........Hope you understand my gibberish!!