Yep, that's always a challenge. And I am regularly on the novice as well as the expert side of that communication breakdown.
That's why attached sample files go so much further than descriptions only or even screen captures. I thought I could get away without, but if you (who apparently has a breadth of Excel knowledge) don't understand me, what hope is there that the OP does?
Anyhoo...here are
a few screen captures of the Name Box that I was talking about. In this case, I selected the A1 address in the Name Box and typed RFA in it to quickly name the cell.
Attached is a sample file of the table automation and the resulting formulas. See in Column C how the formulas are descriptive rather than merely referring to addresses.
I'm not sure if this makes my original post any clearer.