Please try something like:

    =query({Sheet1!A1:B10;Sheet2!A1:B10},"select Col1, Avg(Col2), count(Col1) group by Col1 label count(Col1) 'Number of times referenced?', Avg(Col2) 'average'")

Adjust ranges to suit those you did not mention.

[QUERY](https://developers.google.com/chart/interactive/docs/querylanguage)