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

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!

Please Login or Register  to view this content.

Here is my attempt, but the last line is incomplete. WSR is the page where I want the results to go. The theta and alpha variables are created based on user input, and already calculated in an earlier part of the code.


Thanks for help in advance!