Compare two values in different sheets and pull them if one is lower than another

Hi all,

Another head-scratching question I am asking myself. If I have two sheets, one for stock information and another for the orders, how do I effectively satisfy customer (how do I avoid shorting customer) as there are thousands of products in my workbook. It is quite difficult not to miss one.

So, question:

Is there a formula or set of them to compare two values (stock and order) and retrieve all information (product, stock, and order) if stock is lower than first two oncoming orders in ten days from today?

See the sample workbook.

Thanks to everyone involved in solving my little problem

Well, actually I need to pull off only those products that are low stock, not all, as there are thousands of them. In the main sheet I want to be able to see only those products.