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.