Help...Auto save Data to another sheet and clear sheet....

Hi,
i have created an invoicing page in excel and linked the customers with vlookup. only the details that need to be filled are unlocked rest all is locked. when i make an invoice my customer details is updated but i also need the details of the invoicing like Party name,invoice number, date, product and value for future reference in another sheet. Is it possible to save these data automatically to a different sheet and clear the invoice for next entry.


Please help

Thanks

http://wikisend.com/download/681340/...Invoicing.xlsm