I have a complex series of calculations that I want to run several times,
using different inputs. Let's say that on Worksheet 1, I have an input in
cell A1 and some output in cell A15. Then on Worksheet 2, column A is the
series 5, 10, 15, 20, etc. I want column B to the output of that series; in
other words, B1 would be the output is A1 (5) were the input, B2 would be the
output if A2 (10) were the input, B3 would be the output if A3 (15) were the
input, etc.

I remember doing this several years ago, and I can't remember how I did it.
Any help would be appreciated.