Macro to copy data from one sheet to a master sheet with running totals

Is this possible?
Sheet 1 employees will fill in information with set dates and products used 1-4 row entries (varies) across 17 columns. I have a macro that will then save this sheet as a new file and then clear the data/entries so this file can be used again. I want to also send this data into a master sheet that will track all entries as a running total?? I am hoping I can create a macro to take entered data on sheet 1 and enter into next available row(s) on a master sheet - before sheet 1 is saved and cleared?

Similar to creating an invoice and wanting to keep track of data in one or two steps.

Thanks for any help.

Could you post an example of your workbooks so that we can see what range you are referencing?

Thanks!

here is an example

Thanks