Vlookup index match across multiple sheets and average values

[goblue667]

I have a list of Golfers in my "Summary" tab where I want my vlookup to find the golfers name in each of the four sheets and then look at a specific column and average those values in the summary sheet. Is this possible? I have been looking around and have not seen anything pertaining to the same index match across sheets....

 

[goblue667]

Above is the Summary sheet that I need Finish Position to be averaged across all sheets.

Above is what Sheet 1,2,3,4 look like. I need Column A to Match column A in Summary sheet and then Column B is the values I need averaged.

 

[Fluff]

Create a list of the sheets that you want to average & then name it SheetList.
You can then use
=IFERROR(SUMPRODUCT(SUMIF(INDIRECT("'"&SheetList&"'!A3:A30"),A2,INDIRECT(SheetList&"!I3:I30")))/SUMPRODUCT(COUNTIF(INDIRECT("'"&SheetList&"'!A3:A30"),A2)),"")

 

[goblue667]

Create a list of the sheets that you want to average & then name it SheetList.
You can then use
=IFERROR(SUMPRODUCT(SUMIF(INDIRECT("'"&SheetList&"'!A3:A30"),A2,INDIRECT(SheetList&"!I3:I30")))/SUMPRODUCT(COUNTIF(INDIRECT("'"&SheetList&"'!A3:A30"),A2)),"")

So create a new tab and list the sheets with their exact names and then call the tab SheetList?

and then put that formula in column B and then fill down?

 

[Fluff]

Not quite, you need to create a list of the sheets, on the summary sheet or a new sheet, then select the cells & in the name box type SheetList.