Hey Guys, I am working on a project for my local volunteer fire department where we are trying to track frequency of code use. We fill out a template daily that contains certain codes within two columns we wish to track. Along with the name of our volunteer and the department or Platoon they are assigned to. After completing the template we store it in folders based on "Platoons" ie; "Platoon A", "Platoon B" and so on.. Now we want to track the code usage and frequency by month so we can get totals for the year. Here's where things become tricky, I am trying to put together a formula or code that will go into each of the folders and extract these codes. My research tells me that this can be achieved with the use of SUMPRODUCT as it will search and extract information from closed files. Once it finds this information it will extract it to a source file for further calculations such as totals and such which I will apply filtering to within the source sheet. I have attached a couple of screen shots of the "From" template and the "To" or Source file I want the extracted data to be placed. Any ideas on the bet way to perform this task would be greatly appreciated. I am open to any and all suggestions as I have tried several with no positive results thus far. I am using 2007 to do this with, thank you in advance for your help.