Macro to Compile Data from multiple workbooks in a network folder.

[hoyterco88]

Hi all,

I am very new to VBA and I am looking for some help to set up a macro to compile all the data from multiple work books from a network folder than can be selected when the macro is initialized. All files will be .xls file format and the files will all have the same data in them. What I would like to do is have it pull data from Column C starting at row 14 ending at row 200. The data will be in the same location on all work books. I also need the names of the data from the first file that is opened to be copied in the first column in the new workbook. The names will come from Column B starting at row 14 also. Can someone please help me get this part set up. Once I have that I think I can edit the rest to look like and do what I want.

Any help is appreciated.

Thanks!!!

P