Multiple Excel Files; One cell info. And Date Modified.

[joe_0_1]

Hello all.

I have 849 invoices in one file on the C drive.

They are all randomly named, with no structure.

location

C:\Joe's Work\Clients\Motorwise\Customer inv

I need the value of cell E8 in one list, and E39 in the other.

Eg.
___A____B
1]1001 £100
2]1002 £200

The other problem is that he has dated the invoices as =today() so I am unable to establish invoice date. Am I able to detail the date the file was last modified in this spreadsheet at all?

Appreciate any ideas.

If The above is not possible, I would be happy with every file merged into one worksheet.

thanks in advance