I have a need to define cell A1 like so :
=CONCATENATE("System Name: ",D2," ",D3)

but instead of a fixed D2 & D3, I would like to replace it with E2 & E3 if I
click on column E, F2 & F3 if I click on column F, etc... i.e. cell value
will be dependent on which column I click on.

Is there a way to do this ?

Thanks,
ak