How can I run a spreasheet over range of input data ?

I have set up a work sheet that takes input data (a number) from a cell, goes
through all kinds of calculations based on other cells, and finally puts out
a results in a output cell.

Using this sheet, how can I sweep the input data over a range (min,max] and
record the output data over the sweep?

Thanks for any hint.
--
Bernd