I am trying to create a Task Tracker spreadsheet.

The first tab is a summary for the boss. The successive tabs are all names of the team members. Each team member goes into their tab and fills in the data in four columns (Task, Status, Progress, Issues/Comments).

If the Status column is either OPEN or HOLD I want it to feed the Summary tab. I can't figure out how to pull the data from the later tabs to the front sheet if the Status values are the ones I want.

Any ideas?