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

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.

What is a co-relation between Raw Materials Inward sheet & Production Entries sheet.
Input manual required result in respective cell.

As far as Raw Materils Inward sheet below formula
In "B2"

Formula:

=SUMIF('Raw Materials Inward'!B:B,A2,'Raw Materials Inward'!C:C)

In "C2"

Formula:

=IFERROR(LOOKUP(2,1/('Raw Materials Inward'!B:B=$A2),'Raw Materials Inward'!A:A)," ")

By Pressing simultaneously shift+ctrl+enter

"Batch Quantity" are number of units (?) so Item1, V1, Raw Material 7 will be 10 gms *100 (batch Qty) ? grams on 02 March

In "Production Entries"

Columns G:T calculate Usage (Kg) for each receipe

in G3

=SUMPRODUCT((Recipes!$A$4:$A$63=$C3)*(Recipes!$C$3:$G$3=$D3)*(Recipes!$B$4:$B$63=G$1)*(Recipes!$C$4:$G$63))*$E3*0.001

copy across and down

"Recipes" reformatted

in "Raw Material Stock on Hand"

in B2

=SUMPRODUCT(('Raw Materials Inward'!$C$2:$C$15)*('Raw Materials Inward'!$B$2:$B$15=$A2))-SUMPRODUCT(('Production Entries'!$G$3:$T$12)*('Production Entries'!$G$1:$T$1=$A2))

in C2

=IFERROR(LOOKUP(2,1/(INDEX('Production Entries'!$G$3:$T$12,,MATCH($A2,'Production Entries'!$G$1:$T$1,0))<>0),'Production Entries'!$B$3:$B$12),"")

Clearly define all the units (grams/kilograms) in all the tables