Help with Excel Form autopopulating into another sheet.

Hello,

I have a excel form which I use to input catering information. I input the data and then sort it with a timestamp so that the most recent information is at the top.

There is a separate sheet that takes this data and puts it into an easy to read page which looks much like an invoice. It takes the data input from the top (most recent) original excel form and displays it as an invoice. In this case, this is ROW 2; b2, c2, d2 etc.

If I needed to reproduce an invoice, how would I be able to take any of the forms and show them in the invoice sheet? If I insert a row and copy and past, the invoice no longer takes information from ROW 2, and it reassigns the !form as ROW 3; b3, c3, d3, now.

Hopefully someone can help.

Thanks