Dynamically name excel sheet

And if i need to paste in desired sheet then i need to loop through all sheet names ?