Multi-table Merge

Hello everyone,
I have a question. For merging my three tables, I used append, Merge and other activities, but although he works, he will lose a lot of data. Is there a better way to deal with it? I will provide test files.
Text3.xlsx (30.9 KB) Text2.xlsx (30.9 KB) Text1.xlsx (30.9 KB)

Result.xlsx (32.7 KB)
This is the result file I want to get