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?

On 2nd worksheet, you always can use formulas to calculate summary results based on data you entered into 1st worksheet!

You could try out Scenarios, it's under What-If Analysis in the Forecast section of the Data tab of the ribbon.
You can set up a number of scenarios:
2022-11-25_162038.png

then click on Summary and you have a choice of output:

2022-11-25_161836.png


It's not often used but it's not bad.
Attach a file so that we can demonstrate?