Why such complicacy?

In a single excel workbook, on one sheet create a table of all materials - with material as leftmost column, and other parameters for material in same row.

In another sheet, you have formula(s) table, where one column is for material. You enter there a material (in same format as in leftmost column of materials table, and all parameters for this material are read into next columns using Excel VLOOKUP() formulas.