Need Help Creating Master To Do List - Open items from "Project Worksheets" to Summary
I found a starting template for a Master To Do List (I can't take credit for the attached starting worksheet). My hope is to have multiple worksheets (one for each Project) and a Summary Worksheet. What I am trying to do is pull only the open items from each of the multiple worksheets and populate the Summary sheet. I need the summary sheet to be dynamic/update regularly (either by a button or automatically) with closed items no longer appearing and new items appearing on the Summary.
I have searched and found possibilities, but am new to VBA and Macros so am not sure how to even start. My starting/draft template is attached.