Trying to build an automated schedule

I have been trying to create a macro that would create a schedule for me based on date and a product type. In columns K-N I have an IF statement that tells when a shipment would need to arrive in a row that corresponds with a date (column A is 1/1/2015 - 12/31/2015). On the next page I would like to generate a schedule that lists the dates that all of the products are needed in chronological order. I've tried to use custom functions like finding the nth_occurence but it just gets way too messy with so many shipments. Any help would be great, thanks!

Thanks for the help but that will not work for my problem. There are a lot more than 4 products that will be consumed and there will be several dates that have multiple shipments and for those dates I need the output formatted as:

1/2/2015 Prod1
1/2/2015 Prod4
1/4/2015 Prod2
1/7/2015 Prod2

How can I get the data to go from what I have to that output?

Thanks again for the help

That was a poor example that did not come directly from the sheet I attached. Based on the attached sheet the following should be the beginning of the output:

1/2/2015 Prod1
1/5/2015 Prod2
1/6/2015 Prod3
1/7/2015 Prod4
1/12/2015 Prod2
1/12/2015 Prod3
1/14/2015 Prod1
1/14/2015 Prod4
1/18/2015 Prod3
...and so on

That was a poor example that did not come directly from the sheet I attached. Based on the attached sheet the following should be the beginning of the output:

1/2/2015 Prod1
1/5/2015 Prod2
1/6/2015 Prod3
1/7/2015 Prod4
1/12/2015 Prod2
1/12/2015 Prod3
1/14/2015 Prod1
1/14/2015 Prod4
1/18/2015 Prod3
...and so on