How to link two Google Docs (Excel)?

Question

Google Sheets

Hello!
Please help me link two Google Spreadsheets. (not sheets, namely two different documents)
There is one table, let's conditionally call it "Warehouse" and the second table with the catchy name "Dispatches", as the tables look like, you can see on the screenshots.
Is it possible to make it so that when entering the article number in the "Shipments" table, one unit of goods is automatically deleted from the "Warehouse" table from the "Quantity" column
For example, there is a pillow shipment, we have 10 pillows in stock, we enter this shipment in table, and in the second table in the column "Quantity" remains 9.
I would be glad for any help =)

Answer 1

And how does the product get to the warehouse?) (this is a kind of hint that the current state of the warehouse should be the resulting table from the income table and the consumption table)