Hi all,

I have a small company that receives orders via an excel file. The excel order forms are always exactly same. I've attached an example order form. These orders all go into one folder. I need to keep track of how much we are selling of each item in a master excel file. Is there a way to extract the data from each file in the folder and add it together into a master excel file? This needs to be a simple solution, since we are continuously receiving orders and need to continuously update this master file.

Thanks in advance for the help,
Kyle

Order Form.xlsx