Function INDIRECT
The INDIRECT function provides you to create dynamique references by using the cells' contain as part of your references.
build custom cell reference
How to Reuse the Cell Value (reference) in a formula
When you start learning Excel, it's important to understand how you can reuse the content of other cells in your formula. It's very easy.
