VBA Macro to calculate values in cell(s) from multiple sheets

Greetings to the greatest trouble shooting team we have around,

I am stuck in a situation where I have multiple sheets in a workbook, say this workbook contains information/details of every day for a month.

- Sheet name appears as - 368_14_11, 369_15_11, etc.. [batchId_Date_Month]
- On these sheets we have values [digits] from Cell C30:G34.

Requirement -
- We need to create a [Summary] sheet in this workbook.
- Sum the values of Cells C30:G33 [individually].
- Paste them on the same cell range i.e. [C30:G33] in a [Summary] sheet.

Note: We can remain following the labels as it is on [Summary] sheet as well.
Cell B29
Cell B30
Cell B31
Cell B32
Cell B33

An immediate assistance in the above request would be highly appreciated.

Thank you and Best Regards - ajaydwivediji