Hey @myakkhaing these are the steps you have to use
create a string variable which -store the folder path
create a array of string - and use directory.getfile method and pass the folderpath which holds the files location
use a for each inside for each use excel application scope and inside the excel application scope pass the currentitem which get all the files one by one and inside excel application scope use read range
PS- your sheet name is fixed so use the name and if is not fixed and you only want the first sheet and use getworkbook sheet after read range use merge datatable activity and outside the loop use right range .
so for writing use 1 build data table activity clear all the columns and row data inside the build datatable and create a variable in the build datatable and pass that output in the write range and check the write range add header option also enable the preserve format in the read range activity.
if this activity is available for you you can use it otherwise use directory method
cheers