You need to break it into parts. To select the last row you need to determine how do you identify the last row. Hopefully you have an ID column that is an identity column so then it is really easy.
SELECT TOP 1
FROM table1
ORDER BY ID DESC
To insert parts of this record into another table is very easy.
INSERT INTO table2 (field1, field2, field3)
SELECT TOP 1 field3, field4, field5)
FROM table1
ORDER BY ID DESC