Sorry for the unclear request, it's probably because I am not a programmer and over several months have created a very convoluted and inefficient macro, by recording sequences of key strokes, pasting them together and adding code from kind helpers on this site. The equations are all hard coded with numerical values and names that only work for the current dataset, e.g. subtract 2.5 from each cell of column "ABC". When I get another data set I go in and edit the macro's hard coded values and strings. Although there are only 5 or 6 values to change they are in 5 different macros in 15 or 20 different places and I inevitably miss one. Instead of a hardcoded value in the macro equation I want a pointer that will go to another sheet in the workbook and read the values to use. The proper approach would be to write the macros with variables. My poorboy approach is to retrieve a string or value from a specific place in another sheet of the workbook. In effect the macro says "In Sheet 2, Subtract the value that is in cell A1 of Sheet1, form every cell in the column of Sheet2 that has the name as given in cell B1 of Sheet1"

Would it be easier to explain to me how to substitute a variable for the hardcoded strings and numbers, and then read a file that updates the variables????