从不同的电子表格复制到单个电子表格表格中

I have different excel spreadsheets that contain tables with the same structure and the same header. I need to conserve the header in the first spreadsheet and copy the tables of the other spreadsheets one beside the other in the first one, without repeating the header every time. I have 150 or more spreadsheets, it takes a long time to do it by hand. How can I solve this problem with a programming language like Python, C# or excel VBA? I saw similar questions but I didn't manage to solve this problem with the answers given to those questions.I have different excel spreadsheets that contai