Speed up max if array

This is excellent Colin,
The Pivot Table option gave me instant results, woo hoo!! Unbelievably fast!!
Not totally au fait with returning the max value back to my sheet.
Sheet1 is my pivot table with all my max values. Equipment worksheet contains all my data. I need to return the data back to Col L2 on the Equipment worksheet but showing the max value against every row where ID occurs, if you know what I mean.

ID Value Max Value
1 3 3
1 1 3
2 1 2
2 2 2


Does the Pivot Table and data have to be on the same worksheet for this to work?

Thanks for your interest and help