VBA loop through list

Awesome, thanks so much!! It works perfectly. Made my day.

I should've thought of this question earlier, but at what stage of your code could I insert some formatting code? I'm hoping that it could be part of the loop so that the formatting is applied to each created sheet?

In relation to the last bullet point above could you please show me how to do option 2.? I would want the new data to override the existing data already in the sheets from the last time the macro was run.

Hope I'm not abusing your generosity with your time here :/