I want solution of this problem

Problem :: I have a excel in which there are more then one sheet name and i want to create another excel file in which i can write all the sheet name as column name and in all the sheet.