display of table in different Sheet

So i have a table in which i have data which i need in different sheets. i have attached an excel sheet and how i need the data. i have done it manually of two products but i need it for all. Is there any way that the data is displayed automatically like i desire it to be. please use formula in the sheet so i can copy paste as i have not extreme knowledge of excel. please find the attached sheet.

The simplest and fastest way to get the required results is to create a Pivot Table on the data in master sheet.

Attached one sample for the same. You can explore more on this. Rate and Quantity Inwards table should also present in the same workbook in order to populate that data. Currently I am using Pivot table's calculated field to populate the rate and to calculate Total value.

But i cant change the rate for the different customers

To change the rate in different table, Click on Pivot table then on tool bar 'PivotTable Analyze' menu will appear.

Go to PivotTable Analyze=>Fields, Items &Sets=>Insert Calculated Field=>In drop down you will find Rate


You can also have different table for Rate which you can use to pull data to this table.