Dynamically name excel sheet

But if i give desireable sheet name it will just have one sheet name . I need 3 different sheets for 3 different files i am copying