How To Persist Excel References In Formulas Across Worksheets Where The Worksheet Is Blank?

Is it possible in Excel to create a template with formula to other named empty sheets such that the references to the cells always remain and don't end up like this? ='Data'!#REF!

Solution 1:

This was solved using Named Ranges.