Exporting a record to another sheet

Hello,

I have a query regarding transferring a row of data from one sheet to another. Basically i have a userform which displays all the records in my master sheet. I need some code to go behind an export button that;

- deletes the selected row from the master sheet
- copies it to the next available row of the 'Export' sheet

Ideally would want this to be code that copies the data from the cells....not from whats loaded into the text boxes on the userform.

Can ne1 help?

See attached file for current work.

Many Thanks to all

Tom