My office has weekly timesheets, a separate file for each week.

The timesheets have project numbers in column B, a date (column A), a 2 digit number rate code (column C), and the time spent (column F).

What I need is a macro program where I can enter the project number and it will will look up and retrieve the data in column A, C, and F for all the files.

We are constantly creating new timesheets each week so it would need to know to look at all the files in the folder. The project numbers are five digit numbers.

For example:

Input:
Project No. 23023

Output:
Date, rate code, time spent
Date, rate code, time spent
etc.

Is there a way to do this?

Thanks