Excel VLOOKUP AVG function? Plant Metrics

[controlfreak]

Hi guys,

Hope someone could help me out with this.

Basically I'm trying to streamline the way my company does it's metrics. I have a sample excel sheet attached. This data is copied and pasted into excel every week from our documentation operating system.
The numbers in red as you scroll down are time averages for that particular product stream which have to manually inputted which can be time consuming.

Would there be a way i could paste this info into excel and for it to insert these averages for each product stream automatically? It doesn't matter where these averages are placed, they don't have to be directly under the respective product stream.

Thanks for any help offered!