#25815 improve error for missing yml files when using $ syntax

Especially when moving your schema around, it's easy to misplace a yml file that is defining dynamic content. This will raise a `TankError` which has useful detail but is quite cryptic. This improves the error a bit while retaining all of the details and offers a possible solution that the specific yml file is that defines this dynamic content may be missing.