Hello, I'm trying to gather some ideas.

I have to pull reports from a logistics system. The logistics systems cannot connect with excel.* The raw data goes in to excel that links to Access which cleans it, queries it then exports it to excel.

The problem is, I want to keep historical information so I can see changes in orders, inventory, etc. I can only pull the data, copy it in to excel then it exports that "point in time" information.

In summary 1 raw data workbook -> access with 20 queies -> exports to 1 excel workbook with multiple sheets by report name.

Regarding historical database design, how can manage multiple databases to give me historical information so I can make graphs, track trends, etc?

Ideas?