Hi,

It looks like copy7.htm is the closest to what I'm trying to achieve, the
network drive in particular. Hoewever, I'm not sure exactly what he is doing
there or why especially with the timer, it would appear that he is copying a
block of data from a single sheet.

I need the file path to be constructed from the value in "A2", for example
\\"A2 value"\"A2 value".xls information in those workbooks is contained on
several different sheets and I would like it to populate the cells on the
same row on the same sheet as the column containing the file names. How do I
go about doing this?