Solution for iterative calculation of result for 3 variable product cost.

Hi,

Problem:
* There are 3 products and the cost of every product is calculated by each separate table (Table- Product A,Product B, Product C).
* There is another table which is having combined cost of all of these as well as expense which are common to these (Table - All Products Data with combined cost).
* The data of each and every table change once I change the Number of Products in top rows.
* I Need Automatic calculation of gross total for different Quantity of products for forecast in Analysis Table.

Please refer the attached excel.

Regards,
Almas