=CELL("address")
This brings the selected cell reference. Use the INDIRECT function do do whatever you want with it from there on.
Note that simply selecting a cell won’t trigger the change. Once you select a cell, press F9 to calculate the sheet to get the proper results.