Creating an evolving table from random amounts of data

Hello,

I'm an intern with very little experience in VBA. I thought knowing C++ would be an advantage and jumped on this task, but now I'm stuck.

I've been trying to create an excel workbook which can import daily production reports in different workbooks into one sheet and then create a summary table (in same sheet) which includes the amount of each separate product produced.

I'm finished with the macro for report importing thanks to previous posts in the forum.

The tricky bits are, and I really can't figure them out:

It imports from a folder, and the user puts the files that he wants summarized (can be 26 files for monthly summary or much more for yearly, or just 3 days that he wishes), so the amount of reports is variable.

The reason I call it evolving is because they don't always produce the same types of products, because the company is project based. So the table needs to change each time I summarize different reports, find what's been produced that day in Assembly for example, and add both the name and amount. Then if the same product's been produced the next day it should add to that.

I've attached the example wb:
MACROTRIALS.xls

Edit: The tables on the left are imported reports, dotted borders include product names and total amounts produced. Tables on the right are just my visualizations of how the finished tables may look like.

Thanks in advance,

Can Berk Sansoy

Thanks a lot