Once I've entered all the data to the last cell in the row, I'd like this
"active" sheet to send that row to an "archive" worksheet.
Basically I will then only have a live sheet to work from which will only
remain live until I've filled in the final cell.

Any ideas?

Tom.