String and Value workbook reference

Instead of editing my Excel macro to change a string, I would like to edit another worksheet of the workbook and read the variable name from that information sheet into my macro.

So if my macro contains a line;

And Cells(1, i) <> "FLOWA2" _

and on another run I want it to be "FLOWA3" , I enter FLOWA3 in an information worksheet 'Sheet1, cell A1'. How is it referenced in the macro???



Similarly for a value. If my macro formula subtracts 1.23 as below

ActiveCell.FormulaR1C1 = "=RC[-2]-1.23"

I would like to be able to subtract 4.56 by entering that number in an information worksheet 'Sheet1, cell B1'


Thanks,
Jim