Transfreing data from one workbouk to another workbouk

**bobigoca** · 04-06-2013, 11:27 AM

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.

**AndyLitch** · 04-06-2013, 11:50 AM

Can you upload the file please?

**bobigoca** · 04-07-2013, 08:16 AM

HERE IS THE SAMPLE
This is only for JANUARI, and I have 12 same worbook from jan to dec.
then i have also same for 3 months(jan,fev,mar), 6 first moths, etc.
and 1 main for one year.
Now I need to copy datas from every cell from every sheet that hold numbers from every workbook from
jan to dec into 1 workbook for whole year.
Hope that explain it my need.
Thanks again for your efort
With regards.