Macro to copy details from one worksheet to another

Hi,

I have created a macro in a sheet named " Invoice" where the details once entered and saved gets saved in separate workbooks enabling me to view it later. But i need to be able to create a report for them in another workbook named "Reports" summarized by the categories in the invoices set. The forms are attached.