Copy paste to different tab base on multiple conditions

Hi all,

Been struggling with this for a while and been through several posts and cannot seem to get a solution together to accomplish what I need. Basically I have a spreadsheet database that sevral people have access to and can add data on the the Full List tab of the attached (full source file is over 15,000 rows). Monthly there are several groups that need to take action based on the entries, and I am trying to script a conditional paste of values and in some cases formulas out to the other sheets based on a few criteria for row on the Full List so that the other sheets can be handed over to other departments.

Case 1: a row has a date entered in Column A and B, and todays date is < the date in Column N
Action 1: Do Nothing

Case 2: a row has a date in Colum A, but no date entered in Coulmn B
Action 2: Copy that row values in Columns D,E,F,G,H,I,J,K,L,M,O,T,U on to the 'Add to AM' sheet and the formulas from Columns X-AA to the same destination sheet.
There is no need to preserve any existing data (other than column headers) on the target sheet.

Case 3: a row has a date entered in columns A, B and N, but no date entered in Column C
Action 3: Copy that row values in Columns D,E,F,G,H,I,J,K,L,M,N,P,T,U on to the 'Remove from AM' sheet, and have the values in columns O and S added to paste to column N of the destination Sheet.
Again, There is no need to preserve any existing data (other than column headers) on the target sheet.

Case 4: a row has a date in Column A and B, and todays date is >= the date in Column M, and there is no date recorded in Column N
Action 4: Requires presarvation of any items already exisiting on that sheet, or updating of existing. like the previouse cases, row values would then need to be coppied to the 'Convert to Evergreen sheet as values only for the heads matching those from the 'Full List' and paste over and case where the SN# in column E matches the incoming data.

Feel like this should have been fairly straight forward to code but have fallen flat on my face in all cases.

Any help would be appreciated!

Thank You