I will place the vba code in suni.xlsm
my sheet name can be anything
my all file are in same place
Open the file
Completely Copy the first sheet data of anu.csv(here sheet name can be anything) and paste it to sheet1 of anu1.xlsx(here there can be data in anu1.xlsx if there is data then paste the data below that and if there is no data then paste the data from starting)
close and save the workbook