Screenupdating on open?

I have set up a spreadsheet for work to log notices for discrepant parts. I would like to be able to have a tab that will auto update and filter (without having to be refreshed or updated) that will show only the overdue notices. And also a tab to show only the notices that have been initiated (column B) in the current week and are deemed (column N) scrap. I have set up the linked information in the tabs but cannot get the filters to update how I would like. I found that it worked with screen updating but updating after each cell is logged causes it to freeze up for a minute or so after each entry. Please help! DN log 2013 copy.xlsm