This is just a question about Excels functionability in case i end up investing a lot of time (stress) in trying to do something which cannot be done.

Is it possible for Excel to be able to automatically pull specific information from emails and files residing on a shared drive? If it is, please point me in the right direction.

Thanks.