I currently have a formula in my worksheet to refer to names to wages on
another worksheet, this is fine and works well. But when I insert more rows
(not the last row before the sum) the formula doesn't continue? I have to
ctrl c, ctrl v to keep the formula going in added rows.

Is there a way I can keep the formula going as I insert more rows without
copying everytime?

Thanks
tb