Hey guys, I've got a bit of an excel issue I wasn't able to solve through hunting around for an answer.

I've got a spreadsheet with a main page, along with two other worksheets inside it that I will be adding data into. I've been able to mirror over the columns successfully using the following formula:

=IF(OFFSET('Sheet1'!$A$1,ROW(A1)-1,COLUMN(A1)-1)=0,"",OFFSET('Sheet1!$A$1,ROW(A1)-1,COLUMN(A1)-1))

And by copying that over to all the relevant columns, it means that if I add a row and new name part way through the main sheet, this change is also updated in the other two worksheets. However, when I add in a row on the main page like this, on the other worksheets anything in the following columns doesn't get moved down as well.

1 a
2 b
3 c

1 a
2 b
2a c
3

Hopefully the above helps to explain it. If I add in the row 2a on the first sheet, then it gets added on the other worksheets, but the data against it on that sheet doesn't also get shifted down a row to match, so it ends up mismatched. Given the way the forumula I'm using works, this isn't surprising, but is there another way to make this work?