Macro to copy details from one worksheet to another

Once the data is filled in the invoice workbook and saved, the details gets saved in separate workbooks. i want to be able to prepare a report which the details category wise can get saved in the next available column in the Report Sheet. Please refer the attachment. Thanks