Subtracting From 2 different worksheets

[tivial01]

I am creating a inventory system for my company and I cant figure out how to subtract from my main inventory.

for example

main inventory shows 200 form panels i sent 100 to job site A how to I make it subtract the 100 from the main inventory and add to Job site A?

 

[tivial01]

Ok update Ive figured out how to do it using this =SUM(B3,D3-'309'!B3-'310'!B3) but I will be having around 10 to 15 job sites at one time is there a better way to streamline this?

 

[t0azt]

Would need more information about how your data is set up to be able to help.

 

[tivial01]

ok my Data is set up like this

first worksheet will have the master inventory list
then from there I will be creating separate worksheets per Job site so ie: 309 , 310 , 311 ect.
instead of having to add each new page into the function is there a way to do a array of worksheets?

 

[tivial01]

https://www.mediafire.com/view/pw54chi5e6bq2dr/Screenshot_(12).png/file