If criteria is met in a certain column on the first sheet/tab of a workbook...

I don't know the full picture of what your two (or more) sheets in that workbook are doing, but I will assume that the first one has a number of rows--perhaps hundreds--descriptive of actions in various stages;, and that the second in this case is intended to be a compilation of of all of the rows where column N reads "Full Receipt."

\If that assumption is correct, another way to fulfill that intention would be to dynamically use the FILTER function so that it is always yielding a complete list of all on the first sheet where N reads "Full Receipt," not one by one filling them (via a macro or VBA routine perhaps). This way (using FILTER) that second sheet will remain accurate even if you discover you'd made an error and needed to change an entry in column N of the first sheet.

Check out ;this video on the use of FILTER (and other Dynamic Array functions). See if it wouldn't serve your purpose.