Change Links to avoid 0 Values showing

Hi, I have a ton of links to other worksheets that since no information is in the orginal cell the results come up as a zero value on the new sheet.

I really cant hide all the zeros in the options as some zero values I need to show but they are a much smaller number so it would be easier just to change all the current links.

What kind of script could I use to edit the current link to include the current link and add a if then statement to the formula.
Here is an example:
From:

='1st Shift'!C15

To:

=If('1st Shift'!C15 ="","",'1st Shift'!C15)

Thank You, Mike