Stock Management Stage-1

Dear All

Myself Manek. Im working for a Windows & doors Manufacturing company. Here we are trying to make a store /inventory management excel for my current company.
What we want is that , when we enter the purchase and sales it should automatically update with the store inventory.

I have attached the excel sheet along with this thread.
The excel sheet has 12 sheets inside
1.Home
2.Glass
3.Aluminium
4.Projects
5.Code
6.Upvc Accessories
7. Aluminium Accessories
8. Glass Accessories
9. Tool Accessories
10.Almimari
11.Veka
12.Purchases

Stage 1 - Automatically update the each specific excel sheet when purchase happens

example

On Purchase Sheet
When we enter Under Code- GLAC01 ,Item- Hinge1 , Invoice No. - 1, date- 1/10/2016 , Qty -50 and finally selecting the drop down list in under store and select "Glass Acc" . these details should appear in Glass Acc sheet .

Same like

When we enter Under Code- UPAC01 ,Item- Espag1 , Invoice No. - 11, date- 11/10/2016 , Qty -75 and finally selecting the drop down list in under store and select "uPVC Acc" . these details should appear in Upvc Acc sheet .

The rest all things in purchase should reflect their respective stores.

Once this is through, Stage 2 is there.

So kindly help me.