I am trying to figure out a way to produce a large number of Excel files quickly. All files would be nearly identical except for the data in one cell (a different name, populated from a list). I am not sure how to go about this, have searched the web but haven't found my specific case yet. In the simple example below I would be looking to create 30 sheets just like this but with a different name in each, populated from a list of 30 names.
Thank you in advance!