Create a "To be ordered" sheet pulling data from multiple sheets

I have a workbook containing inventory of medical equipment. This includes type, minimum required stock, actual stock and expiry dates. There are multiple sheets for different categories of equipment. I would like to create one auto-filled order sheet that adds items from all the sheets when the actual stock falls below the minimum stock or the expiry date is in less than 3 months. Is this possible?