I have created a Invoice template on sheet 1 and I want to transfer the data entered onto a row with headers on sheet 2 and when the data is entered into the template again on sheet 1 I want sheet 2 data to record onto the next row.

Please help I have an Excel Bible and can't find the answer.