I am running a macro that copies and pastes different reports into one
workbook (each on a different sheet) and then does some formatting and
formula calculations on each sheet. I then reference all of those sheets onto
a summary page. I am currently having an issue with one of my formulas. Here
is the formula:

Range("B3").Select
ActiveCell.FormulaR1C1 = "=(Class_" & i & "_Name)"
The "i" is a variable that changes depending on which sheet is being worked
on. The formula works, but only to a point. The cell named "Class_1_Name" has
a formula to Concatenate other cells on the summary page once they are filled
in. They aren't filled in until after the macro is done running (they are
filled manually). Currently what is happening is the value that is
"Class_1_Name" is being inputted into cell B3 on the current worksheet. I
actually want cell B3 to have in it "=Class_1_Name", not just what that cell
contains when it the macro runs. With all of my other formulas, they actually
appear in the cell when you click on it, but for whatever reason, I can't get
the actual formula to appear in this cell. I even tried to do the formula for
the concatenation that I do on the summary page and it does the same thing.
How do I get the actual formula to go into the cell, so that when the
contents of the cells that are referenced change, the cell on the worksheet
changes?

Please let me know this makes sense. Any help is appreciated.
Thanks,
Paul