Weekly Sales Calculation (every Sunday) for pharmaceutical company

collect 7 sheets from 7 distributors

i put them in 1 sheet with master item name and its agreed price

i put these sales into the working teams (each team will take its sales)

i send detailed file has many sheets where each sheet presents sales in a different way.

Power PIVOT Tables.