What I need to do is:

1. Receive emails from various locations (emails are
received/downloaded into Microsoft Outlook on my desktop).
2. Open email
3. Open the excel workbook attachment
4. Select data from the particular sheet called "drd" (fixed no of
columns and but variable no of rows)
5. Paste it on another workbook called "database"
6. Open another email perform step 2 to step 5
7. Perform this process for all the emails received.

I have tried to create a macro but that macro is not running for all
emails. Because:

1. The file name (email attachment excel workbook) is not the same
for all emails
2. The sheet name is not in the same for all workbooks
3. Starting row or starting column is not the same (this happens
frequently but not always).
4. The subject is different for all emails received.

Ultimately what I am trying to do is as soon as an email comes in my
inbox that mail should be opened then the excel workbook is should
be opened and the data should be copied and pasted in one excel work
book to create database. If the database is created, job is done.

I request each and every group member kindly help me how to proceed.