open file base on the list and copy some information.

Hi everyone,...

is there a way using VBA code that I can use to open a file base on the list i have?

What I try to do is to open the file base on the list i have on "List_Master_sample" in col C (List tab) and copy some information from the file just open into the next blank row in "sector" tab. (high lighted yellow).
and this process will continue until all the files information been copies into sector tab .

An excel documents has been attached.

I would appreciate any kind of help on this!

Thanks!