Data table and calculation and input on separate sheets

Not sure I understand. Maybe if you attached the file (or example), it may make more sense.

Greg, See the attached file. Basically, I'd like the price sensitivity analysis on the first tab. The pricing is on the second tab, and the margin (which is the output in the data table), is on the third tab. Note that the contribution margin is calculated based on data that is pulled from several sheets.

Thanks in advance for your help