Consolidate three Excel Files

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

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.