How to configure the Google sheet to import data to a new line when the requirements are met?


So I have a google sheet that I made at work to simplify our product receipt needs, the old sheet was a template and people wrote it all by hand, which creates confusion for the people who store the product.

I am now trying to create a journal for this sheet, in case the original paper flies out of a forklift or gets lost otherwise.

This is used by many people, so I need the journal sheet to know when the receipt sheet is finished and move to a new line before clearing the sheet and starting over.

Currently it is just a matter of importing data from the cells of the receipt sheet and I don't know how to insert a nested formula saying IF this cell, this cell and this cell are filled, go to a new line and import the receipt sheet cells here now.