Archiving 4 weeks of data into Month folders

[mosh]

hey All, my first post.

I need to archive data in a spreadsheet every month, this is a workbook
that is referenced to 4 weeks (1 spreadsheet per week). Here is a more
detailed outline of what i have;

Every week a productivity sheet for each manager containing peoples
overall scores. This is done for each week. I have a monthly
productivity that references each week results for each manager and
then a column for a monthly overall average.

Currently all of the weekly files are kept in one folder (each manager
has own folder) so I can reference the links to each week, but the
problem being I have to keep changing the references when I need to
view data for another month and the folder will start getting full
rather quick due to the amount of weeks worth of data.



Is there a way of also referencing the data to the month for the
monthly sheet and to also archive one months worth of data in a folder
i.e. "June".

Help appreciated. Thank You.

M

 

[PY & Associates]

The process could be automated if we can see the file structures please.