Combine excel sheets to a masterfile

Question

I need to write a program to combine a particular sheet of every excel with the same title row.
My aim is to make a masterfile in excel workbook format.

Each excel has the same title row
Each excel has 3 sheets in it. I want to create a masterfile of the third sheet.

Answer 1

Try the openpyxl library. Should work for your use case.
https://openpyxl.readthedocs.io/en/stable/usage.html#