Clicking on Data sheet and have it make different sheet required Summary

Dear Team,


I am attaching a sheet.in this data sheet is master sheet.we make the summary for different product by using pivot table.

for example in this 2204 we used pivot table and made the summary.same we have done in another 6101 sheet.

please help me if we can make it by using macro vba.


thanks in advance.