Excel 2007 : index/match formula but I need the data to change depening on what date I put in

I have 2 workbooks, one is where we enter the data into and the other one is where I want it to sorts the data.

Sample- T ------I want the data to come to this book from sample- t2 and then depending on my date I put in to take the information. So when I enter in the date I want it to look at sample- T2 and take the information that was from that date and transfer it to the sampe- T book.

Sample- T2 ----- This book is where we would enter the all of the data, it is the master book.

I have a formula that I use to take the information from the sample- T2 book to sort it by growers but now I would like to do a sheet where it does it by the date.
formula is no the Sampe- T workbook that I use to transfer by grower.

Thanks

I can't get it to work.

In the sample- T2 I enter I enter that in a6 but then it make the cell blank, it takes away the date that is in it.

In the sample- T I enter the other one and than make that blank.

Sorry.

Do I put the helper formula in AG? or A? on the sample T2

I need them to sort to the right columns for the date. so all of grower 1 goes under grower 1 and so on.

I got it to transfer over to the page but when I change the data it doesn't change anything. what do I have to do to make it change with the date.

also how do I get it to look at grower 3.

=IFERROR(INDEX('[Sample- T2.xlsx]Master SC'!$U:$U,MATCH(ROWS(I$12:I12),'[Sample- T2.xlsx]Master SC'!$AG:$AG,0)),"")

Awesome thanks. It work in the sample one let me try to transfer to the actually one.

It worked great in the sample. I can't get it to put the grades in. I got it to put the date in. and then did the other part in AG but I can't get it to work in the other book.

This what I have in the box. I have the grower name in A4 and then the grades I was trying to put in B6 and down but it won't work. Does everything look right?

=IFERROR(INDEX('[2012 Tart Cherry Check Grades.xlsx]Master'!$U:$U,MATCH(TRIM(SUBSTITUTE(LOWER(A$4),"Grade",""))&"_"&ROWS(B$6:B6),'[2012 Tart Cherry Check Grades]Master'!$AG:$AG,0)),"")

Here is the date formula, this is working. ='[Tart check grades by growers.xlsx]Daily Grade Comparison'!$A$2