I would like to sum up values held in various worksheets. I am trying to
track inventory for each new purchase order created, each new purchase order
will be created by a new worksheet. In other words, I am trying to lookup
and sum values in worksheets that are not yet created. Any ideas?

Your help is appreciated.
Dave