Formula help please

Hi Donna,

Step by step explanation of the pattern is here http://www.exceltactics.com/make-filtered-list-sub-arrays-excel-using-small/4/ (not only, at many other places). In addition here are some comments within your formula

=IFERROR(
   INDEX('[Production Sheet Template.xlsx]Sheet1'!$A$4:$H$33,
      N("range to find is entire template from row 4 to 33")+
      N("could be change on dynamic or take with the gap, e.g")+
      N("change 33 on 333 everywhere below")+

      N("SMALL returns the first row number there the X is found")+
      N("for the first cell in destinitian list, defines by ROW(1:1)")+
      N("when the copy down that will be second position ROW(2:2), etc")+

      SMALL(
         IF('[Production Sheet Template.xlsx]Sheet1'!$E$4:$E$33="X",
            N("IF returns array with row numbers where X is found")+
            N("and zeros otherwise. Here we make 1 for the")+
            N("first row in the range")+

            ROW('[Production Sheet Template.xlsx]Sheet1'!$A$4:$A$33) - 
            ROW('[Production Sheet Template.xlsx]Sheet1'!$A$4)+1
         ),ROW(1:1) + N("counter for the SMALL - 1,2,..")
         
      ),3 + N("number of the column in template range from which")+
            N("we pickup data")
   ),""
)

Above is in the cell A8 in the attached file, for the rest i removed comments.

Result shall look as

The DPR will only open at the end of the Day, and I only need to fill the top portion of the DPR sheet. But i want the production sheet to link to the DPR sheet