merge/join/combine multiple tables into one master table

I had this question after viewing multiple table in one worksheet into one master table using userform.

here i attach sample file for this question. In sheet1, contains many/multiple tables with different no of column, only have same column for Id and Name. I want to combine/join/merge all tables in sheet1 to be one master tables(can be refer in sheet2). is there any vba code/script i can use for this? thank you.

Book1.xlsx