I have a lengthy worksheet which requires a single numerical input on A1 and
it produces a single numerical output on F30. It has numerous formulas.

I would like to apply this operation to a series of input data listed on,
say, cells M1 to M20 and to produce related results on cells N1 to N20.

Is there a simple way to achieve this?