Need help aggregating data

What I have is childishly basic, but for now it is functional. I haven't done any serious excel work in about 10 years. I would probably have to completely recreate the whole thing to get any workability out of it.

Basically I'd like the first page to be a master listing showing where each item number can be found. Please forgive my lack of knowledge on the matter. Thanks for your help.