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.