Updating Array Formula

Hi Guys,

I have opened another thread for this as I have tagged the previous one as solved.

In the previous thread, a formula was given (Thanks to DILIPandey). It works fine, however, I was unable to tweak it as I needed to add some sheets to the formula.

Here's the old thread: http://www.excelforum.com/excel-form...le-sheets.html

Here's the formula I need to update:

=IFERROR(INDEX('S1'!$E$2:$XFD$2,0,MIN(IF(('S1'!$D$3:$D$6=Summary!E$2)*('S1'!$B$3:$B$6=Summary!$C3)*('S1'!$E$3:$G$6<>""),COLUMN('S1'!$E$3:$G$6),""))-4),0)

I would like to add S2 S3 and S4 versions of that code so that it will also look into those sheets.

Another thing, would it be possible to add a formula that will load a value for Ph1 - Ph11 from the index sheet to S1-S4 sheets? Also, I would like the formula to determine the date the value in C column has been added and return a value under that date and stop any consecutive fetching after a value has been added to a row. Please see sample.

Also, would anyone point me to a guide on excel formulas, especially look ups with specific conditions.

Thanks in advance, happy new year guys!