Send cell through another workbook and return answer

thanks for all your help.
please see attached simple layout of what I am trying to achieve.
I have added comments to the cells to try to explain.

in the real life example the "data input sheet" will be hundreds of rows long. so hundreds of different individual input values.

also the "calc" workbook is very complicated, with multiple sheets and many many formula.
I just want to input my values into the start of this and output each answer at the end.


thank you