Consolidate Multiple Workbooks Into One And Push Back Down Updated Data

[myexcellent123]

hello- yes, for protection of specific filenames i have removed the exact filepath...but it does reference Microsoft Sharepoint files