Formula

=IF(ISBLANK(Alexander!D25),””,Alexander!D25)
The formula above was written to move information from multiple worksheets into a master worksheet and display a blank cell when no information is listed. BUt, when you delete a cells information from the individual sheets it changes the master to a #REF!. Is there anyway to keep this from happening. Or would it be better to just link the cells and turn off the Zero option.