Hi brymc81

Looking at your Workbook/Worksheets I'd think you need to add a separate "Status" column to each worksheet and create the cross reference referred to below to accomplish this
when a task is marked complete on the committee worksheet, the master task list will also reflect the update
To do this
It would also be nice for new data entered into a committee worksheet will appear on the master task list
there'd need to be a cross reference between the Committee worksheets and the Master. At this point I don't see one. What's the "DUN" field?