Consolidate three Excel Files

Help
1

Hi i have one problem
3 bots are running on different machines using queues
so in 3 excels there alternatively paste the output by leaving blanks
now i want all the input data continuously in one excel line by line which the 3 bot does how can i achieve these attaching the sample excel and the output required

2

Read all three Excel files and merge the data tables.
Filter the data table where any column data is not empty.
Save the filtered data table to excel file.