I need a macro that vlooks up the value in wrksht 1.Range("C1"). I want a loop that loops through wrksht 2.Range("A2:G2) values. So I want the macro to take A2 copy and paste in wrksht 1.Range("C1") then make a copy of wrksht1 and pastes into a new sheet and name the sheet as wrksht 1.Range("C1"). then loop the the remaining values in row 1 and do the same.

Thanks