Transfer row to another workbook based on cell value

[pixyrene]

Good day.

I need a VBA for the following.
We have a sheet with cells in Column N where the word "Fail" appears if the criteria was not met, based on an IF formula.
I need the row to copy and paste to a different workbook in the next available row, if the word Fail appears in the cell in column N.

Any Ideas?

 

[pixyrene]

More information on my question.
The sheet i'm using has locked cells.
Preferably I would like the name of the sheet as well as date and time also shown in the workbook where the information is copied, don't know if this is possible.
The workbook where the information is copied to is to keep record of all the information that failed. These tests gets done multiple times per day, so the time and date is important as well as the workbook's name from which the information was copied, as there will be multiple different ones used.