I have 3 Excel files and each one has multiple sheets [T1(sheet1, sheet2..,etc), T2 (sheet1, Sheet2,..etc), T3(sheet1, sheet2,...etc). The names of the sheets in all files are identical and the name of the fields in each sheet are identical too but fill with different data. I need to join or merge each sheet from one Excel file with the corresponding one from the others based on a common field (ID) and have one excel file.
I did different attempts but I did not get the right results. Could you help please.