Transfreing data from one workbouk to another workbouk

I need to automaticaly transfer data from all sheets in one workbook to all sheets in another workbook.

I have 12 identicaly workbooks for each month with diferent data. So I need to add (sum) all data from those
workbook to yearly workbook.also this will be done for 3 months, 6 months and yearly.
Thanks to all for helping.