Try the following code assigned to a button (on each sheet):-
Application.ScreenUpdating = False
.AutoFilter 12, "No"
ActiveSheet.Next.Range("A" & Rows.Count).End(3)(2).PasteSpecial xlValues
Application.ScreenUpdating = True
Application.CutCopyMode = False
It will operate from the active sheet (on whichever day) and transfer all relevant rows of data with a "No" in Column L to the next sheet.
I hope that this helps.