This is pretty straightforward, but your workbook is in a big state of "No" values right now. So I think the best solution is to simply have the OVERDUE sheet collect up all the "No" rows (based on the NOTES column K) each time you activate the OVERDUE sheet.
1) Right-click the OVERDUE sheet tab and select View Code
2) Paste in this sheet event code:
3) Exit the VBEditor and save as a macro-enabled workbook.
4) Now enter some "No" values in column K on the other sheets, then come back to the OVERDUE sheet and it will offer to update for you.
Bookmarks