Auto Relocating

I have files that are missing... yet are in the collection.  Please PLEASE make a function that sees this and automatically replaces the missing files with the one in the collection and associates the cues, colors and other data.

Thank you SO SO SO much for thinking about this.  It really would help a lot, especially considering how expensive this product is.