extract data from excel

I have a large excel file and I need to extract data to another excel file, creating one tab for each element . While this can be done using pivots this will be very time consuming. I need help to be able to extract this data using tools like python etc. I would like this to be done over a zoom or virtual call.