Excel summary sheet – possible?

We have an excel spreadsheet with many sheets, each corresponding to a different customer. CSRs fill in the fields on each page, including column that indicates if we “missed a promised date”. It works well for them, but not for management, who wants a summary page of all the instances where we missed the mark. Is there a way to generate a summary page that looks at all sheets and whenever a cell is filled in (to indicate a missed deadline), it copies the entire line (or just certain cells fromit) over to the summary sheet?