I have multiple excel files (one for each type of contract), but I need to submit a report listing all active contracts by parter company (plus the names of each contract manager, the value, etc). Each partner company has a code it is identified by, and I am looking for a way to extract the info based on these codes. I am familiar with macros but not programming. Is there a simple way to do this?