I have a worksheet with a button that adds another row (thanks to Leith Ross). I want to be able copy this row(s) to another worksheet.

I can easily copy the first four cells in the row as they are each named ranges, however if there are additional rows in the source worksheet, I cannot copy them by e.g. =Range Name + 1 etc. to copy the cell below.

Is there a way of doing this, possibly without VB?