Hi,
     I need help desperately.Any Kind and brilliant geniuses out there to help?
I've various excel workbooks(which contains various worksheets each).
I need to retrieve & generate a summary report based on the common fields found from these various excel files & from their various worksheets.

Based on the sumamry report generated, i need to auto send out reminder emails to respective people,2 weeks before the action_due_date(1 of the common field that could be found in the summary report generated).

I wonder how can it be done.Maybe using microsoft Access.
Please kindly help.Thanks a million:)