I'm wondering what would be the best way to have hisorical excel files saved so that they are in a central location. I'm looking for any input on the following structure, maybe I shouldn't even use excel. I'm just starting this project so I would like to get a lot of input now before I begin developing.

Looking to be able to print off a specific report/document/page/format (whatever you want to call it) for each of the 100 departments that excutives look after. These reports are called Department Profiles, they list information that is specific to each department only. The users will not enter new information very often, usually the entire group of profiles (100 of them) will be due each month. When new information is entered, it will likely be very small changes (if any) while the rest of the report stays the same. Each monthly set (100) of reports (possibly single excel file with 100 worksheet tabs) will have to be saved so that they have historical integrity, thus the historial records (spreadsheets, files, reports, whatever you want to call them) will remain the same if viewed in the future.

I'm basically looking for the best way to have these 100 reports that are due each month is a central place, regardless of whether they are in access, excel, etc. Is there a way to make excel files be contained in an access database so that you could have a list of excel files (named by date) within the database that will open if you click on it in the database.

Is there a way to have excel files or worksheets in some type of database so that they can be searched? In other words, there a program that will allow you to put excel files in a database for future reference while providing search capabilities?

Is there a way of creating an excel spreadsheet so that it will allow you to search worksheets or excel files in another excel file?