I have a simple table where data is gathered from another worksheet (lets
call it WS2), the formulas look something like:
Col A Col B Col C Col D
J Smith =WS2!G4 =WS2!G7 =WS2!G10
B Jones =WS2!G5 =WS2!G8 =WS2!G11
H Walsh =WS2!G6 =WS2!G9 =WS2!G12

When I duplicate a row (in order to create a new one) I was expecting the
references in the formula to automatically adjust, e.g. the cell references
would become 4,5,6,7 in column B, 8,9,10,11 in Col C and 12,13,14,15 in Col
D. But they don't - the cell references in Col B are 4,5,6,6 and Col C & D
are unchanged.

I am sure they automatically adjusted in another spreadsheet but I cannot
figure out what I am doing differently. The above is an example, the
actual spreadsheet is very large hence me wanting to avoid manually changing
all the formule. Can anyone help?