Merge multiple excel file sheets into single excel file with multiple sheets

Can you elaborate? If Sheet1 is unnecessary, please remove it after merging.