Inventory sheet with Raw Materials, Products & multiple versions of recipes fr each prdcts

[inventoryguy]

I am very new to Excel formulas and started learning recently.
I am attaching a spreadsheet which i want to use for tracking the inventory of raw materials used in production.

Page 1. Raw materials Inward : Entries of incoming raw materials are going to be manually entered on this sheet.
Page 2. Production Entries : Manually entered
Page 3. Recipes : Recipes of different items are entered along with different versions of the same recipes.
Page 4. Raw Material Stock in Hand : I am stuck here. As per the raw material inward entries on page 1 and production entries on page 2, i want to apply formulas for the Raw materials stock in hand and the last date of stock movement, which is either purchase or production.

Could anyone please help me with this.