how can I write back to source excel file when I get excel data from data tab?

Question

So, I want to create one Excel file each for every manager with only one single sheet and place it on OneDrive.

In order to get the data in one place, I am creating another excel file called combined.xlsx.

Now, I can export each workbook to a tab using Data -> Get Data -> From File -> From Workbook .

This is great so far. So, I can read data of 10 excelfiles on 10 sheets in combined.xlsx.

Now, I want to modify contents of one of the tabs and make sure it is reflected to the original file. How can I do this?