Unifying different tables in only one table to explote that info

Hi all,    I have 6 sheets with the same header, and i want to match in a dynamic table to unify and be able to exploit the information   Specifically the sheets contain members of different team...