Creating Macros to Open, Update, and then save the file at in a new path

[omeng]

Here is my question:

I want to create a macro on a master Excel workbook, where I can open a list of excel workbooks listed in Column A by A1, A2, .....

Then, after open all of them, copy a range of cells from my main excel workbook and paste(update) the same corresponding range of cells to each of the excel workbook listed in A1, A2, A3.....

Finally, after update completed, save each one of them by a new name under the same or different path (better).


I appreciate if someone could give me help on this.


Thank you!