Transfer data from one workbook to another automatically each week.

I am in charged of transferring data from one work spreadsheet to another spreadsheet (basically just copy/pasting it). So we have 7 different departments for the spreadsheet and there are team membe...