Yes this is Excel 2000.

It is based off of multiple workbooks, for Example, I want the values in E22 Mountain Hoop1 to match the last row of H in Hoop3, and then the same for River, and the same for stream.