Thanks for your replies...

Here is a sample file: http://www.sendspace.com/file/zd1tht

What I'm trying to get is a weekly summary for sheet "Hours Bills". The most
important information is in column F & H. It would be nice to pull all of
this information to get a summary for each employee. The goal is to pull
weekly results, but it would be nice to enter a specific date range and get
the employees production. Columns J:N are normally hidden but used to get
production results. It's a simple formula - Bills Worked (column F) / Trailer
Hours (column N).

@Socko that would be perfect but I would have to go through too many files
(unless there is an easier way).

Hope that makes more sense.