Consolidating data to a single page and adjusting formulas

Attached is a very small sample of what I am working with. I'll be completely honest, I am a complete novice when it comes to excel and the use of formulas and all of the formulas currently being used have come through the assistance of other users of this forum and and extreme amount of trial and error. I would even go so far as to say that there probably is an easier way of doing this and not 100% sure that my formulas are completely accurate but it's the best that I have come up with so far. With that said, here is what I'm trying to achieve.

1. Display the latest pick information and also use this information to determine who needs to still submit a pick.
2. Display statistical information based on type of pick and it's historical comparison to previous year (using the dates in columns Y & Z to determine)

When I first started, the group was relatively small, but now it is over 200 members and my original process for updating data was to insert the new data for each of the members on their respective worksheet. My goal is to use the consolidated sheet "Members", in order to avoid the tedious process of having to do so for each of the 200+ worksheets I have in my production file. My issues are as follows:
1. When using the combined "Members" sheet, how would I be able to pull in the latest pick data for each of the members (i.e. columns B, E, F, G & H on the "Main" sheet)?
2. How can I average the "Last 10 & Last 20" for each of the members, since my current formula uses the simple formula based on the first 10 and 20 picks in each of the members worksheets?
3. If I can end up using a single "Members" worksheet, how would I adjust my formulas being used in rows I-V in place of the current use of Indirects?

I'll stop there and say ahead of time THANK YOU for any and all assistance anyone can provide.

Thank you again for your assistance, couple of questions.

1. I noticed in the column O of the members page, it is assigning a year value (presumably from the data in column B) however the actual "year" for the league is based on the date ranges shown on sheet "Main" in Y2 & Y3 for 2016 and Z2 & Z3 for 2015.

2. Since the member data will need to be consistently updated, my initial thought was to insert that data from an external source into row 2 of the member page each time. So with that said, would I then need to sort by member and most recent date in order to group by member in chronological order? And, if so, how would this affect the data in the rows M, N & O that you created in the "Member" worksheet?

So here are the formulas that I am using and they seem to work, the only problem that I'm having is when I try to sort the all of the references to the member in cell A appear to keep the original A cell value from before sort. I hope that makes sense. Also, I am using the sheet name "NFL" rather than the previous use of "Main", FYI.
Pick Date =SUMIFS(Members!$B$2:$B$200000,Members!$A$2:$A$200000,NFL!$A2,Members!$M$2:$M$200000,1)

Last 15 =AVERAGEIFS(Members!$H$2:$H$200000,Members!$A$2:$A$200000,NFL!$A2,Members!$M$2:$M$200000,"<=10")

Last 30 =AVERAGEIFS(Members!$H$2:$H$200000,Members!$A$2:$A$200000,NFL!$A2,Members!$M$2:$M$200000,"<=20")

Pick League =INDEX(Members!C$2:C$200000,MATCH(NFL!$A2&NFL!$B2,Members!$N$2:$N$200000,0))

Pick Game =INDEX(Members!D$2:D$200000,MATCH(NFL!$A2&NFL!$B2,Members!$N$2:$N$200000,0))

PIck Outcome =INDEX(Members!G$2:G$200000,MATCH(NFL!$A2&NFL!$B2,Members!$N$2:$N$200000,0))

Pick Line =INDEX(Members!F$2:F$200000,MATCH(NFL!$A2&NFL!$B2,Members!$N$2:$N$200000,0))


NFL =AVERAGEIFS(Members!$H$2:$H$200000,Members!$A$2:$A$200000,'NFL'!$A2,Members!$C$2:$C$200000,"NFL")

NFL Picks =COUNTIFS(Members!$A$2:$A$200000,'NFL'!$A2,Members!$C$2:$C$200000,"NFL")

NFL 2016 =AVERAGEIFS(Members!$H$2:$H$200000,Members!$A$2:$A$200000,'NFL'!$A2,Members!$C$2:$C$200000,"NFL",Members!$B$2:$B$200000,">="&'NFL'!$Y$2,Members!$B$2:$B$200000,"<="&'NFL'!$Y$3)

2016 NFL PIcks =COUNTIFS(Members!$A$2:$A$200000,'NFL'!$A2,Members!$C$2:$C$200000,"NFL",Members!$B$2:$B$200000,">="&'NFL'!$Y$2,Members!$B$2:$B$200000,"<="&'NFL'!$Y$3)

2016 Under =AVERAGEIFS(Members!$H$2:$H$200000,Members!$A$2:$A$200000,'NFL'!$A2,Members!$C$2:$C$200000,"NFL",Members!$B$2:$B$200000,">="&'NFL'!$Y$2,Members!$B$2:$B$200000,"<="&'NFL'!$Y$3,Members!$I$2:$i$200000,"True")

2016 Over =AVERAGEIFS(Members!$H$2:$H$200000,Members!$A$2:$A$200000,'NFL'!$A2,Members!$C$2:$C$200000,"NFL",Members!$B$2:$B$200000,">="&'NFL'!$Y$2,Members!$B$2:$B$200000,"<="&'NFL'!$Y$3,Members!$J$2:$j$200000,"True")

2016 Dog =AVERAGEIFS(Members!$H$2:$H$200000,Members!$A$2:$A$200000,'NFL'!$A2,Members!$C$2:$C$200000,"NFL",Members!$B$2:$B$200000,">="&'NFL'!$Y$2,Members!$B$2:$B$200000,"<="&'NFL'!$Y$3,Members!$K$2:$k$200000,"True")

2016 Fav =AVERAGEIFS(Members!$H$2:$H$200000,Members!$A$2:$A$200000,'NFL'!$A2,Members!$C$2:$C$200000,"NFL",Members!$B$2:$B$200000,">="&'NFL'!$Y$2,Members!$B$2:$B$200000,"<="&'NFL'!$Y$3,Members!$L$2:$l$200000,"True")

NFL 2015 =AVERAGEIFS(Members!$H$2:$H$200000,Members!$A$2:$A$200000,'NFL'!$A2,Members!$C$2:$C$200000,"NFL",Members!$B$2:$B$200000,">="&'NFL'!$Y$2,Members!$B$2:$B$200000,"<="&'NFL'!$Y$3)

2015 NFL PIcks =COUNTIFS(Members!$A$2:$A$200000,'NFL'!$A2,Members!$C$2:$C$200000,"NFL",Members!$B$2:$B$200000,">="&'NFL'!$z$2,Members!$B$2:$B$200000,"<="&'NFL'!$z$3)

2015 Under =AVERAGEIFS(Members!$H$2:$H$200000,Members!$A$2:$A$200000,'NFL'!$A2,Members!$C$2:$C$200000,"NFL",Members!$B$2:$B$200000,">="&'NFL'!$z$2,Members!$B$2:$B$200000,"<="&'NFL'!$z$3,Members!$I$2:$i$200000,"True")

2015 Over =AVERAGEIFS(Members!$H$2:$H$200000,Members!$A$2:$A$200000,'NFL'!$A2,Members!$C$2:$C$200000,"NFL",Members!$B$2:$B$200000,">="&'NFL'!$z$2,Members!$B$2:$B$200000,"<="&'NFL'!$z$3,Members!$J$2:$j$200000,"True")

2015 Dog =AVERAGEIFS(Members!$H$2:$H$200000,Members!$A$2:$A$200000,'NFL'!$A2,Members!$C$2:$C$200000,"NFL",Members!$B$2:$B$200000,">="&'NFL'!$z$2,Members!$B$2:$B$200000,"<="&'NFL'!$z$3,Members!$K$2:$k$200000,"True")

2015 Fav =AVERAGEIFS(Members!$H$2:$H$200000,Members!$A$2:$A$200000,'NFL'!$A2,Members!$C$2:$C$200000,"NFL",Members!$B$2:$B$200000,">="&'NFL'!$z$2,Members!$B$2:$B$200000,"<="&'NFL'!$z$3,Members!$L$2:$l$200000,"True")