How to automatically loop values into a formula and place in new sheet

[kcombs]

I am attempting to pull four values from four different sheets, and plug it into a formula. Then, send the result of the formula into another sheet.

I've attached a mock-up of the workbook that resembles the actual sheets I need to pull data from.

For example, I essentially need to take each sheet's "A2" cell value and plug it into a formula (probably using an Evaluate function?). Then, send the result of the formula into another sheet's "A2" cell, and repeat with A3, A4...B2, B3...,etc.

I have the function and know how to plug values into it - I just need help to figure out how to essentially "loop" through all the values in the sheet(s) and get them into a sheet with all the results.

In the actual data, there is text prior to the data starting, so I would be helpful if I could set bounds on which cells are plugged into the formula. For example (using the attached sheet), if I could bound the formula to only being applies to cells in rows 2-10 and columns A-D.

Thanks!