Cell D3 has a value of 3

Cell A3 has a value of 047853002508

In cell I3 I used the following formula: =CONCATENATE("=A",D3)

The result is cell I3 has a value =A3. I want the value to be 047853002508 which would be the result of the cell reference =A3. If I type =A3, the result is 047853002508.

Why doesn’t the concatenate function treat the result as a cell reference?

I assume I’m doing something wrong and I hope I explained this correctly.

Thanks.