I do it with esignal's dde quite a bit. Here's what you do.
In cells on the same row put = in one, then RediLINK|'L1'!', then =A1 (the symbol in the original location), then ;LP'. Say you've put those in E, F, G & H. Then in I you type =concatenate(E1,F1,G1,H1)
Drag that formula all the...