Record result of a formula multiple times

[maw444]

I have a Worksheet with in which you enter a number, and it gives you a result having performed several calculations to get to the result.



i would like to create a table on another worksheet, which summarizes the results for a range of inputs.

the only way I can think of doing this is manually enter the number into the worksheet, note the result, and then log it in the table on the second worksheet.

is there a function which I can use to automate this?