Copying Value Into Another Workbook When Criteria Has Value NO In Another Column

The requirement is Copying a col. B value when the criteria that there is value 'NO' in column C or D. The value of col.B should be pasted into another excel workbook called 'Deliver_Error Log'.

I have pasted the Sample checklist and the Deliver_Error Log.
Sample checklist.xlsx and Delivery_Error Log.xlsx

Condition 1: Example in the Sample checklist row. 8, 9, 10 & 12 have value No in either of the column C or D hence the value in col. B of row 8, 9, 10 & 12 must be pasted as 4 new available next row items into the Deliver_Error log into col. L (Error subcategory ) i.e Sample Checklist ,row 8,value col.B = next available row of Delivery Log with col.L (Error subcategory )as Col.B (Q-Checker CheckList) and it must also automatically fill the Delivery_Error Log col.B(Data type) as "Error" and copy the Object Name (value in C2 of sample checklist) into col.E (Object name in log).

Condition 2: If all the values in the checklist are Yes in Column C and D then Copy the Object Name (value in C2 of sample checklist) into col.E (Object name in log) and set Date type as Delivery

Condition 3: If value in checklist is blank or NA take no action.

There will be one Deliver_Error log but multiple checklist of different Object names.