I have a workbook that I need a summary page that will breakout 2 different
tabs and subtotal it

Is there a way that if 1 tab holds
Part #, Desc, and Price

Another tab holds
Total Price for the type of project it is
So that would be: Model, List Price

In a Summary tab I would like to show
Item # (this would automatically start numbering each row) depending on how
many choices they made in the other tabs
Part #
Description
Model
Length of term
# users
List Price

They could choose anywhere from 2 parts to 15 parts how do I get it to
automatically populate for what they chosen in this new tab?

Thank you