Breakdown of stock at month end of each

Hi,

I am building a data model which require vba help involvement.I have presented two worksheet.One is 'Existing data' and another is 'Required'.I expect solution at worksheet 'Required'.My end results are from L9 below and across.

Necessary explanation are mentioned in Text Boxes.