There should be some way to easily find all of the reports that reference a sheet, either by keeping a list on the source sheet of all reports that reference it or by adding the ability to search by report source sheets.
The use case is, I think, obvious. If you're making big changes to a central document [like a roll-up sheet], you'll want to update all of the reports that reference it. Currently there is no easy way to find all of the reports you need to change. You either need to hunt for reports by hand or more likely make the changes & see what breaks. There has to be a better way!