Convert Text in formula bar to a formula

[johnnyL]

I have
="=Sheet1!B" & (QUOTIENT(ROW(), 5) + 1) in the formula bar

=Sheet1!B2

is displayed in the cell

I want the formula bar to show the current result displayed in the cell or the formula bar to display an actual formula that will yield a correct result in the cell

In other words the formula bar should show something similar to: =Sheet1!B" & (QUOTIENT(ROW(), 5) + 1)
And the cell should return the result of that formula, in this case: Quotient Test #1

What the heck am I doing wrong? Besides the obvious ="= in the formula bar. How do I make the guts of that a formula?

 

[Alex Blakenburg]

You don't just mean this do you ?

=INDIRECT("Sheet1!B" & (QUOTIENT(ROW(), 5) + 1))

 

[johnnyL]

You don't just mean this do you ?

=INDIRECT("Sheet1!B" & (QUOTIENT(ROW(), 5) + 1))

You know I do.

Thank you @Alex Blakenburg!

 

[Alex Blakenburg]

My pleasure. Nice to be able to help you for a change.