Open Office - using cell text to reference another cell?

[Battlepants]

First of all, sorry if this is in the wrong section... it may not be programming, but it damn sure feels like it!

Ok, so here the situation, I want a cell to contain the letter for the reference cell that will be copied all the way down the page. So, if that didn't make sense, lets try it like this.

Assume B1 contains D

So, I want to have a column that will use the contents of D1 as the first part and its own row number as the row. So, working in the C4 cell, I want it to pull the contents of D4 into itself (for later dividing, but that's not important now)

So, using the CELL function, I manage to get C4 to display the string "D4" in itself by using...

=(CELL("CONTENTS";$B$1)&4)

One would assume that since it properly returns the string, that one could simply feed this into another function...

=CELL("CONTENTS";(CELL("CONTENTS";$B$1)&4))

But that calls a bad reference error (assuming this is because I am calling a concatenated string rather than a true cell reference via an = command?)