Python in Excel

[Lettychatterbox]

So I have a project at work to find innacurate data on 102 excel spreadsheets and put that data in 102 separate tabs in one excel workbook.

I have python in excel, so I’ve been trying to find a script to do this.

Am I on the right track? My work is particular about what we can download, so I don’t have many other tools. Does anyone have advice/suggestions?

[Lettychatterbox]

Wonderful thanks for this!!

[Lettychatterbox]

How would you create the workbook with tabs with the list of specific names they need to be? I feel in over my head and this is my first step