I have this formula that works fine, is there a way to replace the file to
reference a cell, so that I can just change the file name in one cell rather
thn the many the formula appears in?

=IF(FILE'!$C4="","",'FILE'!$C4))