Hiding !REF# Error using =indirect() function

I am setting up a summary sheet that contains =indirect() functions for workbooks that don't exist yet.

I would like some kind of function that returns the =indirect() function correctly if the workbook exists and just a 0 or blank if the workbook doesn't exist.

I would like to have the indirect function in all of cells that as soon as someone creates a workbook it will update the summary sheet.

Does anybody have a workaround for this issue.

Thanks in advance