Transform range but with links - automatically and without of Kutools

[tasic89]

First,

I have a table like this.

2nd team	robin	magic
2nd team	kevin	knicks
2nd team	tobin	lakers
3rd team	maria	knicks
3rd team	una	magic
3rd team	alex	lakers
4th team	bob	lakers
4th team	dean	magic
4th team	larry	knicks

Than I what I do is copy all in other sheet as "links". I have now everything as =example!D10, E10, F10 etc etc.

Now for my needs I need all of this converted as =example!$D$10 etc etc.

Now I need all of this in this order

robin
magic
kevin
knicks
tobin
lakers
maria
knicks
...

BUT ALL OF THIS AS LINKS. With fixed links as I edited, because i see that as only way it will work. The only way I know how to do this right now is via Kutools and that option TRANSFORM RANGE and than RANGE TO SINGLE COLUMN. (i keep references)

Is there any way for poor people to do this somehow ?

p.s. I also need this for my final template table as robin, magic, kevin, knicks, tobin, lakers, maria, knicks... but that i can do with simple builtin transform range option