Spreadsheet: 846668d1697802534-collate-data-from-another-sheet-depending-on-month-selected-in-dropdown-list-sample
Sheet: Sheet2

 | Reports |  | Months
 | Report 1 |  | February |  |  |  | Sample 1 | Sample 2 | Sample 3 | Sample 4 | Sample 5 |  | Sample 1 | Sample 2 | Sample 3 | Sample 4 | Sample 5 |  | Sample 1 | Sample 2 | Sample 3 | Sample 4 | Sample 5 |  | Sample 1 | Sample 2 | Sample 3 | Sample 4 | Sample 5 |  | Sample 1 | Sample 2 | Sample 3 | Sample 4 | Sample 5 |  | Sample 1 | Sample 2 | Sample 3 | Sample 4 | Sample 5 |  | Sample 1 | Sample 2 | Sample 3 | Sample 4 | Sample 5 |  | Sample 1 | Sample 2 | Sample 3 | Sample 4 | Sample 5 |  | Sample 1 | Sample 2 | Sample 3 | Sample 4 | Sample 5 |  | Sample 1 | Sample 2 | Sample 3 | Sample 4 | Sample 5 |  | Sample 1 | Sample 2 | Sample 3 | Sample 4 | Sample 5 |  | Sample 1 | Sample 2 | Sample 3 | Sample 4 | Sample 5
 | Report 2 |  | March |  |  |  | 12 | 11 | 1 | 0 | 0.9166666666666667 |  | 15 | 12 | 1 | 2 | 0.6666666666666667 |  | 16 | 15 | 1 | 0 | 0.9375 |  | 22 | 17 | 2 | 3 | 0.6363636363636364 |  | 19 | 18 | 1 | 0 | 0.9473684210526316 |  | 20 | 18 | 0 | 2 | 0.8 |  | 19 | 18 | 1 | 0 | 0.9473684210526316 |  | 16 | 14 | 2 | 0 | 0.875 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
 | Report 3 |  | April |  | Report 2 |  | 11 | 10 | 1 | 0 | 0.9090909090909092 |  | 12 | 11 | 1 | 0 | 0.9166666666666667 |  | 15 | 11 | 2 | 2 | 0.6000000000000001 |  | 13 | 12 | 0 | 1 | 0.8461538461538461 |  | 20 | 18 | 2 | 0 | 0.9 |  | 11 | 9 | 2 | 0 | 0.8181818181818182 |  | 16 | 11 | 4 | 1 | 0.625 |  | 10 | 9 | 0 | 1 | 0.8 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
 | Report 4 |  | May |  | Report 3 |  | 17 | 17 | 0 | 0 | 1 |  | 22 | 20 | 2 | 0 | 0.9090909090909092 |  | 18 | 15 | 3 | 0 | 0.8333333333333333 |  | 19 | 17 | 0 | 2 | 0.7894736842105264 |  | 25 | 23 | 2 | 0 | 0.92 |  | 26 | 25 | 1 | 0 | 0.9615384615384616 |  | 18 | 17 | 0 | 1 | 0.8888888888888888 |  | 21 | 21 | 0 | 0 | 1 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
 | Report 5 |  | June |  | Report 4 |  | 15 | 14 | 1 | 0 | 0.9333333333333335 |  | 29 | 23 | 5 | 1 | 0.7586206896551724 |  | 19 | 17 | 2 | 0 | 0.8947368421052633 |  | 19 | 18 | 0 | 1 | 0.8947368421052633 |  | 32 | 29 | 2 | 1 | 0.875 |  | 14 | 12 | 1 | 1 | 0.7857142857142858 |  | 24 | 23 | 1 | 0 | 0.9583333333333335 |  | 21 | 19 | 1 | 1 | 0.8571428571428572 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
 | Report 6 |  | July |  | Report 5 |  | 14 | 13 | 1 | 0 | 0.9285714285714286 |  | 19 | 17 | 2 | 0 | 0.8947368421052633 |  | 21 | 21 | 0 | 0 | 1 |  | 19 | 19 | 0 | 0 | 1 |  | 25 | 25 | 0 | 0 | 1 |  | 20 | 19 | 1 | 0 | 0.95 |  | 24 | 20 | 2 | 2 | 0.7500000000000001 |  | 16 | 14 | 2 | 0 | 0.875 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
 | Report 7 |  | August |  | Report 6 |  | 8 | 6 | 1 | 1 | 0.625 |  | 18 | 15 | 1 | 2 | 0.7222222222222221 |  | 14 | 11 | 3 | 0 | 0.7857142857142857 |  | 22 | 21 | 0 | 1 | 0.9090909090909092 |  | 24 | 22 | 2 | 0 | 0.9166666666666667 |  | 21 | 19 | 1 | 1 | 0.8571428571428572 |  | 22 | 20 | 1 | 1 | 0.8636363636363638 |  | 13 | 12 | 1 | 0 | 0.923076923076923 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
 | Report 8 |  | September |  | Report 7 |  | 16 | 16 | 0 | 0 | 1 |  | 14 | 13 | 0 | 1 | 0.8571428571428572 |  | 20 | 14 | 3 | 3 | 0.55 |  | 16 | 16 | 0 | 0 | 1 |  | 14 | 12 | 2 | 0 | 0.8571428571428572 |  | 21 | 17 | 1 | 3 | 0.6666666666666665 |  | 21 | 18 | 2 | 1 | 0.8095238095238095 |  | 17 | 17 | 0 | 0 | 1 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
 | Report 9 |  | October |  | Report 8 |  | 24 | 20 | 3 | 1 | 0.7916666666666667 |  | 14 | 12 | 2 | 0 | 0.8571428571428572 |  | 25 | 21 | 1 | 3 | 0.72 |  | 17 | 16 | 0 | 1 | 0.8823529411764707 |  | 20 | 19 | 0 | 1 | 0.9 |  | 22 | 20 | 1 | 1 | 0.8636363636363638 |  | 19 | 13 | 3 | 3 | 0.5263157894736843 |  | 25 | 23 | 1 | 1 | 0.88 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
 | Report 10 |  | November |  | Report 9 |  | 14 | 13 | 0 | 1 | 0.8571428571428572 |  | 24 | 20 | 4 | 0 | 0.8333333333333335 |  | 31 | 29 | 2 | 0 | 0.9354838709677419 |  | 25 | 23 | 1 | 1 | 0.88 |  | 30 | 26 | 2 | 2 | 0.8 |  | 31 | 29 | 2 | 0 | 0.9354838709677419 |  | 30 | 22 | 5 | 3 | 0.6333333333333334 |  | 29 | 24 | 4 | 1 | 0.7931034482758621 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
 | Report 11 |  | December |  | Report 10 |  | 28 | 25 | 2 | 1 | 0.8571428571428572 |  | 24 | 21 | 2 | 1 | 0.8333333333333333 |  | 23 | 22 | 1 | 0 | 0.9565217391304347 |  | 30 | 27 | 3 | 0 | 0.9 |  | 21 | 21 | 0 | 0 | 1 |  | 27 | 24 | 1 | 2 | 0.8148148148148148 |  | 27 | 26 | 1 | 0 | 0.9629629629629629 |  | 20 | 16 | 1 | 3 | 0.65 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
 | Report 12 |  | January |  | Report 11 |  | 23 | 20 | 1 | 2 | 0.782608695652174 |  | 22 | 19 | 3 | 0 | 0.8636363636363638 |  | 26 | 22 | 3 | 1 | 0.8076923076923077 |  | 40 | 35 | 3 | 2 | 0.825 |  | 31 | 28 | 2 | 1 | 0.8709677419354839 |  | 26 | 21 | 2 | 3 | 0.6923076923076924 |  | 32 | 29 | 3 | 0 | 0.90625 |  | 25 | 22 | 3 | 0 | 0.88 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
 | Report 13 |  |  |  | Report 12 |  | 23 | 19 | 3 | 1 | 0.782608695652174 |  | 29 | 28 | 1 | 0 | 0.9655172413793103 |  | 23 | 21 | 1 | 1 | 0.8695652173913043 |  | 41 | 39 | 1 | 1 | 0.926829268292683 |  | 26 | 25 | 1 | 0 | 0.9615384615384616 |  | 32 | 29 | 2 | 1 | 0.875 |  | 32 | 27 | 3 | 2 | 0.78125 |  | 27 | 23 | 4 | 0 | 0.8518518518518519 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
 | Report 14 |  |  |  | Report 13 |  | 24 | 23 | 1 | 0 | 0.9583333333333335 |  | 34 | 29 | 2 | 3 | 0.7647058823529411 |  | 37 | 33 | 2 | 2 | 0.8378378378378379 |  | 35 | 33 | 2 | 0 | 0.942857142857143 |  | 27 | 23 | 1 | 3 | 0.7407407407407408 |  | 30 | 28 | 2 | 0 | 0.9333333333333335 |  | 35 | 32 | 2 | 1 | 0.8857142857142857 |  | 25 | 23 | 2 | 0 | 0.92 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
 | Report 15 |  |  |  | Report 14 |  | 19 | 17 | 0 | 2 | 0.7894736842105264 |  | 20 | 19 | 1 | 0 | 0.95 |  | 27 | 26 | 1 | 0 | 0.9629629629629629 |  | 24 | 22 | 1 | 1 | 0.875 |  | 31 | 29 | 1 | 1 | 0.903225806451613 |  | 27 | 25 | 1 | 1 | 0.8888888888888888 |  | 27 | 24 | 2 | 1 | 0.8518518518518517 |  | 24 | 23 | 0 | 1 | 0.9166666666666667 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
 | Report 16 |  |  |  | Report 15 |  | 12 | 9 | 2 | 1 | 0.6666666666666667 |  | 30 | 28 | 1 | 1 | 0.9000000000000001 |  | 26 | 21 | 2 | 3 | 0.6923076923076924 |  | 38 | 37 | 0 | 1 | 0.9473684210526316 |  | 36 | 33 | 1 | 2 | 0.861111111111111 |  | 29 | 27 | 2 | 0 | 0.9310344827586207 |  | 23 | 20 | 1 | 2 | 0.782608695652174 |  | 32 | 31 | 0 | 1 | 0.9375 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
 | Report 17 |  |  |  | Report 16 |  | 13 | 12 | 1 | 0 | 0.923076923076923 |  | 17 | 13 | 2 | 2 | 0.6470588235294117 |  | 14 | 11 | 1 | 2 | 0.6428571428571428 |  | 31 | 28 | 2 | 1 | 0.8709677419354839 |  | 21 | 18 | 2 | 1 | 0.8095238095238095 |  | 25 | 23 | 2 | 0 | 0.92 |  | 15 | 13 | 2 | 0 | 0.8666666666666667 |  | 10 | 8 | 2 | 0 | 0.8 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | Report 17 |  | 14 | 11 | 3 | 0 | 0.7857142857142857 |  | 20 | 19 | 0 | 1 | 0.9 |  | 24 | 23 | 1 | 0 | 0.9583333333333335 |  | 33 | 28 | 3 | 2 | 0.7878787878787878 |  | 26 | 25 | 1 | 0 | 0.9615384615384616 |  | 23 | 21 | 1 | 1 | 0.8695652173913043 |  | 25 | 24 | 1 | 0 | 0.96 |  | 27 | 22 | 2 | 3 | 0.7037037037037037 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0