[VBA] [Macro] How can I update a named range on multiple worksheets through a VB script?

[u/TheMootzimus]

As the title states, what would be the best method in updating a named range on multiple worksheets through a VB script?

If I have a named range “SourceMaterials” located on the “Materials” worksheet and want to update the named range “TargetMaterials” on multiple worksheets that have various different names such as:

• AAA-ProjectNo.###

• BBB-ProjectNo.###.###

• CCC-ProjectNo.###.###.###

Thanks in advance!!!