Duplicate sheet multiple times and rename each wcomma separated string in cell

Hello,

I have written CreateDimRepors_Click below (sorry - you'll have zoom with your browser to see the screenshot).

Now I want to create a sub which uses each comma separated value found in named cell serial_numbers in place of using named cell quantity_ordered. Basically what I want to do is stated in the green comments, could somebody please help me translate that to eloquent vba?

Screenshot.jpg