Cell references inside quoted text in an INDIRECT formula stay frozen when copied. Build the reference dynamically with ADDRESS and COLUMN, or switch to INDEX for a faster, non-volatile solution.