I have two sheets for example. We will call them Bang and Earlobe.

If on Bang, I have a reference in cell A1 that sets it to be equal to F6 on Earlobe and I change the name of the Earlobe sheet, it dynamically updates.

If I delete the Earlobe sheet, I get a reference, and even if I recreate the Earlobe sheet, it remains a reference on Bang.

How can I maintain the =Earlobe!F6 in cell A1 on Bang regardless of the existence of an Earlobe sheet?