You should loop through the files
For each file you should:
Open a file
Get the value you want
Close the file
And put the value in the master sheet
voila
--
Kaak
------------------------------------------------------------------------
Kaak's Profile:
http://www.excelforum.com/member.php...fo&userid=7513
View this thread:
http://www.excelforum.com/showthread...hreadid=382399