从sheet1循环每个单元格，并始终在sheet2的1个单元格中替换

I had a problem, when I want to use each name from C1 to C21 from sheet1 and insert in nameuser as url address. It suddenly delete each name from Sheet1 from C1 to C21 but it is not replace the destination B2 at sheet2 for every name. I had a problem, when I want to use each name f