Need help - excel macros- printing the info to next sheet

[dh1456]

I need To create a macros
I have attached the spreadsheet below
1. I need to compared 4 sites at a time . For instance I need to compared prices for Address 1 , 2 3, and 4 with same product (Cost ,Selling price and proposed price- Proposed price is not given since it is the price that can be entered manually- Manually meaning individual desired price)-- I did this under comparison tab.
2. Once I compare it, I need a button( by clicking it) it Spits out the summary in the next page. (SUMMARY TAB)

Summary Should Include - all of the information should be for 4different sites)
ADDRESS- NAME OF THE ADDRESS ADDRESS 2 ADDRESS 3 ADDRESS 4
MARGIN WITH SELLING PRICE
(Creating a drop down menu- in column C E G I)- Either Proposed Price or Selling price Depending upon the selection - it spits the price and Calculated margin.
PRODUCT 1 –FOR INSTANCE 10%
Product 2- For Instance 20%
Product 3- For instance 40%


Margin with Proposed Price
PRODUCT 1
PRODUC 2
Product 3 .. and so forth.
IF PROPOSED PRICE is used- I would like to see Discount (both on individual level as well as Total Discount). Also, Some error message to go along with Discount if it is too low.

Total Margin with Selling Price- For instance 20%
Total Margin With Proposed Price – For instance 40%