Good Afternoon,

I have many workbooks in same folder, only name is different but the template is the same.
I want to open one of those many workbooks, run macro and when I make change in any cell, that change get done in all other workbooks which are in the same folder.

For instance when i have only one workbook but multiple sheets, i go right mouse click, select all, and when i make change in one sheet it get done in all other. I want to achieve this but with multiple files.

Can this be done anyhow ?