What have you tried? It ought to be possible (and not too difficult)
to make the warehouse sheet a running total without circular formulas.
Depending on how the table is set up, perhaps DSUM or SUMPRODUCT could
be used in the warehouse sheet. And keep any references to the
warehouse sheet out of the table (first sheet) to avoid circular
issues.

I have a feeling the problem is more in the design of the sheets than
in finding the right formula.