Hi, I need to create a form for our Sales staff to have ability to enter

Currency (USD, Euro, GBP, or YEN)
Edition (A, B, C, or D)
# of Users
Length of Term
Addt'l Products (yes or no) If yes a box should appear with their choices

Then somehow I need their choices to go out to other tabs in the workbook
and get the calculations and prices for these based on their criteria -- Is
this something that can be done in Excel? And then placed in a summary tab?

Thank you,
Heather