Help in developing a workflow

Hi,
The folder has 10 excel files. Each file has 2 sheets. SO the bot needs to read the first file and write the output and then automatically read the next file and write the out put in the sheet like above and so on