Merge .CSV files

Hello all,

I am trying to help my wife. She runs a large retail outlet, and they are currently redesigning their stockroom. To simplify things, I suggested that she only replace, onto the sale floor, what was sold the previous day. In order to determine the total number of items she should routinely stock on the sales floor, it is necessary to determine, per day of the week, what her average sales were. Now, she has a large number of different items and, obviously, not all of them generate a daily sale. She has an inventory program that supports .csv exports. I would like to perform manual searches (generating reports) for the last 10 Mondays, Tuesdays, etc. and have those exported individually as .csv files. Then, I would like to compile each day of the week to generate a Monday (then Tuesday and Wednesday etc) report documenting each item that was sold and tabulating the total number of a particular item sold. So if on the first Monday, she sold 50 black jeans and 30 blue jeans, then on the second she sold 15 and 25, I want the report to show 65 black jeans and 55 blue jeans. When I get my totals, I can simply divide by 10 to determine the daily average sold for that day for each item.

I'm guessing that I could get vba to do this. I have seen where multiple .csv files can be combined into a single file.....but then I want that single file to calculate totals for each item, likely on a second worksheet. I'm hoping that I make some sense here.

I would love to but I haven't created the files yet simply because it will be quite time-consuming to do so and, since I don't know if or how it can be done, I didn't want to waste my time (or yours for that matter). Suffice to say, column A:D (for example) is populated by the name and style of the item. Let's say column E is the quantity sold. So it could read: Shirt, Men's, casual, black, 6. The next item would read: Shirt, Men's, formal, black, 12. This is clearly an oversimplification of the actual files, but I can adjust it if I have the bare bones idea. There would literally be hundreds of rows of information. I would like, on Sheet 2, to look for every instance of Shirt, Men's, casual, black and add the values in column E.

After a bit of research, I found the Consolidate feature, and I think I can get that to do what I want. Thank you.