I need an excel pricing table consolidating from 3 input tables

Description of excel work: Create a table from inputs or a front page from drop down inputs
Extra notes: I need a consolidated table producing from the following: 1. My fixed cost in one cell
This is then multiplied by a type factor in another cell (there are three types) the sum of this is multiplied by another factor which is the term ( there are about a list of 30) and finally this is multiplied by the option chosen (of which there are 100). I would like this in a table (doesn't have to be just one table but maximum of the 3 by type) . If anyone can wants to just do a summary interactive sheet by drop down menu that would be ok too.