Lookup a table of information not just one cell.

Hello, first post on this site. Trying to figure this out as fast as possible

I am trying to create a workbook that will bring up all materials used from week to week and a total to date.
I started by making a data sheet for me to enter material used from day to day.

http://i1080.photobucket.com/albums/...ta%20Sheet.png

The hard part is I need to make it so when you type in a date it will bring up all the data for that week. So say i type in 20160529, It will basically just copy and paste the table for that day from the data sheet to the empty cells below the date on the QPR Materials sheet. this is the formula i am having a hard time trying to figure out.

http://i1080.photobucket.com/albums/...1/mAERIALS.png

so from week to week we can have a QPR report and bring up any other week at any other time we need to check.

I will have a running total of every item used as well. That i think i can figure out.

Any suggestions would be greatly appreciated. This could be simple and i just don't know the formula.

There is a way to use the pivot table like a lookup command? So if i enter the date i want information from, it will pull all the information from the table with the same date and fill out the table on the opposing sheet?

I see, I laid out my data sheet poorly to work with pivot table. I need to put it in 4 columns to do what i want to do.

Sure, give me a day to make sure it all works the way i need and ill get back to ya.

Ya it worked fine. I wasn't able to make it look the way i want but this works exactly the same. It actually looks and works a lot better than i originally planned. Thanks.