Inventory management

We need a software on google sheets
Main sheet will provide summarised data for admin reflecting data from sub sheets which will be updated from respective store incharges.
The stores are
1. Raw material store
2. Welding Part Wip store
3. Assembly Wip store
4. Hardware store
5. FG store