Display List Of Open Items

Hello everyone,

I want to create a workbook that will track "Open" items that are past the due date from project events. I attached a sample workbook to better explain my intentions. There are 4 worksheets. 3 of the worksheets are for different events and 1 worksheet (Summary) to display all open items (Event Name, Task, Status, Date, Responsible Person, and Manager) from all three events. Not all the open items need to be listed, only the ones that are currently past due.

I'm hoping to have an easy way to do this. I'm not sure if I have to use a macro or not. If so, one important factor is that I will be adding new Event worksheets every week and I will need the macro to search them as well.

I hope my explanation made sense. Please take a look at my sample for clarification.

Thank you in advance to anyone willing to take a look at this for me.

- Justin