merge multiple excel workbooks into one
I have say 10 excel workbooks and each workbook has 1 sheet each then is it possible to merge all those excel workbooks into one with 10 sheets? As I am not able to find any such option to the best of my knowledge.
Peter McAnena commented
Surely if this is something you do often it would be worth your while to write a macro for it. That way it will work exactly the way you want it to - renaming worksheets the way you want to to etc.
If you don't know how to write macros speak to your IT department; there will be someone there who can do it for you. It should be about an hour's work.
Your best bet would be using a VBA Macro or maybe Power Query. VBA Macro would probably be the way to go. Just look up how to merge sheets from different workbooks with VBA.