Records of Data

[ayxxn]

Hello all, I was planning to do an inventory app where it records the flow of the inventory. In my google spreadsheet, there are basically 3 sheets:

1. “Scan In” - to see the visibility of their inventory as in where their goods are placed
2. " Scan out" - more of like a picking list
3. Inventory Balance - the balance of each product

Currently, I’m using a formula to transfer my record from scan-in and scan-out sheet to my inventory balance sheet to find the balance. Was just wondering if it is possible to auto record it at my inventory sheet without having me to insert any formulas into my inventory balance sheet?