Automatically assign weights to article names in Google Sheets?

Hello everyone,

I have a specific requirement in Google Sheets and hope for your help in formulating a suitable formula.

In my Google Sheets document, I have two tabs: "Summary" and "Mass." In the "Mass" tab, weights are listed in every other column starting in column C, row 8. The first weight is in cell C8. However, the names of the objects are not directly next to the weights, but rather in row 2, starting with the first entry in cell B2, and are separated by two columns.

In the "Summary" tab, I now want to assign the weights according to the names of the objects from the "Mass" tab. The object names are in column AB, starting in cell B3, in the "Summary" tab. The second object name then follows in cell B4, and so on. In column C, starting in cell C3, the weights should appear according to the corresponding names next to them. To do this, I need a formula that reads the values ​​for column C in the summary tab from the mass tab.

Can anyone recommend a formula that does this automatically without me having to search for each weight manually?

Thank you in advance for your help!