need help to consolidate multiple tabs into master tab

hi, I have a file have multiple tabs, each tab has the same format/row/column, total tabs are more than 100, i need to create a master tab to consolidate all data. Instead of copy and paste, I think Macro can help, but i'm not good at macro, can anyone help? Thank you very much and it will save a lot of my time.
here is the sample file, each tab name is the employee ID, i need a master tab to have 100+ employee data in each column.sample worksheet.xlsx