how do i write a macro that copies a template sheet an names it after a call in another sheet, I want this to loop all the way down a column creating new sheets for each entry.

thanks