"neoschenker" wrote...
....
can solver work with data being pulled from different worksheets? like i
said, goal seek worked but was not accurate enough.
....

Yes, Solver can work with data spread across different worksheets.