Repair Excel Auto-Populate Formulas

The costing workbook I rely on has a front page where I enter item details and figures, and a second tab—“Material List”—that used to fill itself automatically. Somewhere along the way those links broke, so the list now sits empty while the front page keeps updating.

I’d like you to dive into the file, trace whatever formulas or links were originally there, and rebuild a dependable solution. I’m open to whichever approach—VLOOKUP, INDEX-MATCH, dynamic arrays, named ranges, or even a small VBA routine—makes the sheet robust again; I just need the results to flow without manual copy-paste.

The front page contains a mix of text descriptions and numeric values. I’m not entirely sure which columns should map over, so part of the job is analysing the structure and proposing the clearest field-to-field match before you implement it.

Deliverable: the repaired workbook returned to me with the material list auto-populating correctly and any changes clearly highlighted or commented so I can maintain it going forward. If you spot additional efficiency tweaks on the way, let me know—happy to incorporate them once the main link is solid.