I'm trying to create a weekly production summary for some employees, but I
need some ideas/help.

We track production on a daily basis, there is a workbook created everyday
from a template. Each workbook has the name mm/dd/yyyy XXXX X. I need to
somehow create a new workbook that will contain weekly results for employees
for a specific date range. The work weeks are Monday - Saturday and each
shift starts at 00:00. This is on a network and we don't have Access on our
end or I would be using that instead to create a database. SO, I was thinking
of using a user form to select the start and end dates (files) and have it
print the (employee production) for a weekly or given time frame if possible.

Could really use some help on this. My boss decided that we would start a
new incentive program for production results, but like I said above we are
only tracking daily results and it would take me forever to manually go
through each file to figure out the results.