I'm trying to develop a system for purchase orders. I have listed all of our
companies and the relavent products in 10 different worksheets, one for each
provider.

Each day, I will be updating the orders in the worksheets as they come in.
At the end of the day, instead of printing out the entire workbook of
products, I want only the purchases (product, amount, and provider) to link
to a new worksheet of daily totals. Is this possible? How?

Your help is greatly appreciated.