I have two spreadsheets: A and B. B gets all the info from A and as I change the data in A, B reflects that just fine with formulas referencing from it. The problem comes in when I insert a row into A as B shifts the reference and just ignores the new row. Is there a way to make B inserts a new row when A gets a new row?