Extract data from email

[kaffal]

Hi
everyday i receive an email update of our inventory report. This report will be sent to us by several warehouse personal on different time of the day.

I would like to have an macro to extract and consolidate these information from the email and copy to an excel file.

Any idea on how to do this?

 

[kaffal]

http://www.box.net/shared/5ny31sjk7x
Above is an attachment of the outlook which I want to extract to excel.