Reference a cell based on another cell's cell reference
<p>Is there anything that acts like <code>=CELL("contents",A2)</code> except returns the formula from <code>A2</code> instead of the contents from <code>A2</code>?</p>

<p>I want to use a formula from one cell to build a similar formula in another cell.</p>

<p><code>A2</code> currently contains the formula <code>=Tests!B1</code></p>

<p>I want to build a new formula that strips out the <code>B</code> and uses another cells data in my Results worksheet to create a new formula that pulls related data from Tests.</p>