I hope that you can help me:

I have daily reports for the past 6 years, i.e. over 2000 reports.

1) Each report has 4 sheets with a lot(!!!) of different data in them.
2) All the reports have the same format and structure. This means that the
data in the daily report for Oct 14th, 2006 is in the same cells as the same
data in the daily report for Nov 29th, 2009. This means that, for example,
the data for the volume is in cell B3 of sheet 2, in all of the daily reports.
3) All the daily reports have the same name structure, for example: Daily
Report 2007-05-28; but each one is named after it's corresponding date.
4) All the sheets in all of the daily reports are protected with a password
(I have the password).

I need to create a database where all the data from all of the daily reports
will be collected in columns and tables. For example: The data for the
volumes from all of the daily reports will be in a single column with it's
corresponding date in the first column; etc.

Can you, please, help me create a macro to import the data from each daily
report into the each one of the corresponding columns of the database without
me having to open each one of the two thousand daily reports that I have?

Thank you very very very much!!!