I am doing a Current Store Inventory Where i have items in multiple areas

I have a seperate sheet devoted to each area and the first sheet culminates
the overall stock

When i recieve new stock that is not already in my workbook i have to insert
a new row in each sheet and copy the info and write a new equasion etc...
What i need is a macro that will allow me to add new items in my main
inventory sheet that would update data throughout the rest of the worksheet

for instance I recieve new items and place some in the back store room and
some on my redemption wall (archade) I insert the row in the appropriate
place and i want it to update the rest of the workbook in the same
appropriate place and write an equasion that totals the quantity from each
area. i'm not worried about extra stuff ending up on my printoff because of
the filters i have already in place, but if i move an item i would like to
not have to add it to that sheet before i can fix the numbers (and equasions).