Finding a Formula to pull data from multiple columns based on todays date

What I am trying to accomplish is to pull sales data from cells in a column based on the date at the top of the column using the "TODAY()" function. I would like to be able to have the retrieved data show on a separate sheet because I am trying to compare only a few columns at a time out of several hundred columns. I hope that makes sense. You can see on the first sheet "Master Data" the data I am working with. I am trying to pull the data for each product under the date corresponding to "todays date" and "todays date 2014" and place it on the second sheet "Summary" in a column listed under the respective date. I have attached a portion of the info I am working with. I am not sure what formula to use in order to accomplish this or if it is even possible. Any help provided would be greatly appreciated.

Thanks,

David

Add the result in your file (manualy) and post the file again.