You can't do that with a native formula. You would have to use INDIRECT but that won't work with a closed workbook. So you will need the MOREFUNC add-in to use INDIRECT.EXT, or use code to populate the formulas in the first place, or do a manual copy/paste then replace = with = to convert the results of the formulas above to actual formulas.