I use a "Mapping" sheet in my budget workbook that needs to be updated on a regular basis. I have over 100 workbooks and all of them have the sheet called "Mapping".

The 100 files are in one Folder but under different sub-folders.

Is there an easy way to update the "Mapping" sheet in all th files rather than copying one by one.

Thanks a lot for your help

Jijy