We recieve excel spreadsheets that have data on one line on the second sheet
in the workbook as an outlook email attachment. These are all in one outlook
folder.
the one line contains information on customers our sales people have signed
up for our services. It's a standard worksheet that all the salespeople use
and fill out then email to us.

I have to copy that one line manually from each attachment into another
spreadsheet (and eventually to a database). I would like to be able to
automate the copying of this one line into the "table" spreadsheet.

If moving 7 detaching all the attachments to one file somewhere would make
this easier that's not a problem. I just want excel to copy this one line
from each spreadsheet so I don't have to do it manually and past then all in
a single spreadsheet. (also maybe move the files to a "completed" folder
would be nice too).

Thanks for anyones help.