Is there any way to change a field to a blank when a link cannot be updated?

I have a series of worksheets that pull their information from other excel spreadsheets in a directory. When there aren't any files in that directory, I don't want my spreadsheet showing old information - I want the sheets corresponding to missing files to be blank.

Thanks!

-Eleanor