Consolidate Multiple Spreadsheets (consolidate All The Data)

I have a workbook that has multiple tabs and need help trying to figure out how to consolidate all the data. I find myself spending hours doing this manually each day.

Here is what I have:

Workbook has tabs labeled....Wk1_Mon, Wk1_Tues, Wk1_Wed, Wk1_Thurs, Wk1_Friday, Wk1_Summary......and repeats all the tabs through Wk5....then I have a Month_Summary tab.

I have 25 users with 25 seperate workbooks each with individual information on each workbook.

I am trying to get a sum of all the data on the Month_Summary tab for each month for each user and as well as a sum of the Month_Summary tab for all 25 users.

The end result I am looking for is to get a Yearly Sum of all the Month_Summary Tabs for all 25 users as well as individual yearly summaries for each users.

I have one main Folder which contains 25 folders (one for each user). Under each user folder there is a seperate Workbook for each month.