VBA to link cells from One sheet to another

In attachment, I have 6 Sheets. In sheet "Collate", I have linked few cells from other 5 sheets.

For some reason as per my work flow, I need to delete the 5 sheets and create same 5 sheets again.

But as soon as I delete these 5 sheets, the link in Sheet "Collate" Become liks this =#REF!D3. It does not shows any value.

Eben after creating the same sheets with same names the links does get updated.

Can any one help on this?

Is there any code which can link the same cells again to show the value of linked cell.

Cell values.

If you look at the atatched file, for e.g. in Sheet "Collate" G3the value is "11" which is linked with value in Sheet "Information1"

After the deletion of sheet "Information1", G3 of sheet "Collate" becomes #REF!.

After the recrewation of Sheet "Information1", G3 of sheet "Collate" should restore the same value "11". like wise in all linked cells in sheet " Collate"