IF condition for another sheet and whole column

[theorem9]

The goal here it to create a summary sheet.
In that summary sheet I need to reference sheet 1 that holds all the products. Sheet 1 has all the products in one column, but some of them do repeat.
My thought is to create IF statement that could call out one product in sheet 1 for the entire column or index statement if that works better.

I think the issue that I am having is calling out sheet 1
for example this is what I think the index would look like
=index(sheet 1 A:A, MATCH(pens,E:E,0))

 

[DanteAmor]

You can create a pivot table, review videos about the topic, that way it is very easy to create a summary.