Hi there,
Need to input a formula for an inventory spreadsheet where in i can deduct the supplies leaving a location from the total inventory.

There are aproximately 50 worksheets that are deducted from the total inventory,
i.e
sheet 1 =total inventory (part 001)
sheets 2-50 load sheets (part 001 on each)

How can i deduct the total parts from 2-50 worksheets (part 001) to reflect on total inventory (part 001 on sheet 1).

Is there a common formula for this?
Kinda new at this ...any help would be greatly appreciated.

Thanks