I'm trying to get the code to be able to extract the name of the BOM ("Bill of Materials1" in the picture) to be able to use that name, even if it changes, in a macro.

Thanks