I have a spreadsheet of raw data that includes a cost based on a product code. I am trying to create a table that collates that information into an easy to read overview.

This might be a really silly question, but does anyone know how to set a specific range equal to a variable? In the image below, I can’t assign A1:A10 equal to _sheet, for example. In my specific use case, I cannot use the name manager since it tethers the range to a specific sheet.

I have a range of cells that each contain multiple arrays like so. I can extract an array easily, for instance, through =D2.materials

Say I have the following arrays in Excel: