Creating grouped products by one field

I’m trying to create a grid of groups based on my products page category. Each group will have a details page and show me every product that falls under that group. Each group is based on a product number.
Lets say I sell manhole covers for covering street sewers.
In this example, I have 4500 different types.
But I have 4 different groups of materials they’re made out of.
Steel
Aluminum
Copper
Plastic
I’m trying to create a separate page called “material” that would take the material a cover is made from in the products page and put that material name into a single line in a grid and when clicked would show me all the products made of that material. So for this example I’d have 4 lines: Steel, Aluminum, Copper, Plastic. When I click on each line it would only display those products.

Add a connected field to the Products table:

ProducGrid

MateriaGrid