I routinely use a spreadsheet that has one master spreadsheet that sums data
from about 30 "child" spreadsheets in the same workbook. Not all of the
"child" spreadsheets contain data in various cells and will have a "0" if
there is no data to sum. What I would like to be able to do is generate a
list of the "child" spreadsheets that add up to the number in the master. If
there's an error in any of the "child" sheets, it can be very tedious to
scroll through each spreadsheet to see which one is causing the totals in my
master to be off. I'm wondering what is the best way to do this.

Thanks!