Hi @Sadia_Ayaan ,
It is possible to automate this task by using a VBA Macro (if you use Excel on Desktop). I will ask you some questions to we build a solution together:
- Does this first workbook have other worksheets additionally to these 25? If not, the work is even easier.
- Will these 25 worksheets keep the same name in the new workbook? If not, how will you name them?
If you prefer, you can send a sample Workbook just to I check it in more details. You don't need to share the original file, just a sample with fake data that illustrate how your sheets are distributed.