Cell references in Excel are not hard-coded; they are automatically updated if you modify the spreadsheet by deleting or inserting other cells, and unless you use the $ before the col or row they automatically increment/adjust when pasted into another cell.

And you can just name a cell or range if you want to use a variable name to refer to some data in a pivot table or formula.