Hello @diya_poovamma
You can use read range in the 3 different excel files and while writing to single excel, you need to use Write Range activity. In the Sheetname provide your required name.
It will create new sheets and it will write to the desired sheet.
You can watch the below video.But in the write range provide different sheetname and it will create the sheet dynamically.
Thanks