It's going to be kind of long but it is very challenging to me please help
!!!!!
Store 1 = Gold, Store 2 = Silver, Store 3 = Bronze

On worksheet(Customer) Column A there are customer(Store 1, Store 2, Store 3)
On worksheet(Customer) Column B 3 Discount Level (Gold, Silver, Bronze)

On worksheet(Gold) Column A shows all product list (Ex. Apple, Orange, Grape)
Apple - $10 Orange - $20 Grape - $30 (All set price)
On worksheet(Gold) Column B shows all product's Discount % (Ex. 15%, 17%, 20%

On worksheet(Silver) Column A shows all product list (Ex. Apple, Orange,
Grape)
All set price
on worksheet(Silver) column B shows all product's discount % (14%, 16%, 19%

On worksheet(Bronze) Column A shows all product list (Ex. Apple, Orange,
Grape)
All set price
on worksheet(Bronze) column B shows all product's discount % (13%, 15%, 18%

On worksheet (Report) Column A shows all customer list (randomly their name
comes up many times)
On worksheet (Report) Column B shows what product they bought
On worksheet (Report) column C shows what date they bought
On worksheet (Report) Column D shows how much which is Set Price (Apple -
$10, Orange - $20, Grape - $30)

now formula question

On new worksheet (Summary) I want see customer name that's on the
worksheet(Report) & next column I want to see what store owner's make.

I know it's very long but please I had no better way to explain this