You can create a helper column (I use checkboxes personally) called Error. You can then enter the following formula and dragfill on down.

=IF(ISERROR([First Column Name]@row:[Last Column Name]@row), 1)

This will check the box if there is an error in that row. You can then build your report to look across all sheets and display rows where that box is checked. You can then either edit directly in the report or have the report display the sheet name and a unique row id (if already set-up). You can click on the sheet name to go to that sheet and use the row id to find the corresponding row within that sheet.

Paul,

Nicely done! Great solution!

Best,

Andrée

Thanks Andree.

I've been dubbed the SS guru here at the office, so naturally I get an email whenever anything needs fixed. I started building this into sheets that I build for others here about a month ago because people were insisting I had messed something up somewhere. This allowed me to quickly track down the initial error and get it fixed in a timely manner and in turn get back to my real job dealing with clients a little bit faster. Hahaha.