I believe I mean Method 1 as it would be too arduous to manually change the unique sheet names for each individual worksheet as required by method 2.

Apologies if I am incorrect, as I am sure it is evident my vba skills are limited