Pulling a specific value in a specific cell from multiple workbooks

Hello,

I am trying to create a master file for a set of workbooks (About 200) which are all set up identically. I want to be able to pull the corresponding value from each workbook into the correct cell.

I hope the below explains it more clearly,

I have 18 fields (C7, C8, C9, C10, C11, C13, C16, C17, C18, C20, C21, C22, C31, C32, C33, C34, C37, C38) I want pulled into the master spread sheet into columns.

E.G.
Title1 Title2 Title3 etc
C7 C8 C9

The spreadsheets the master sheet is pulling from will not be modified once saved in the folder.

Thanks for your time.

are all the workbooks similar names? eg. blahblah1,bblahblah2 coz you could do that without code.

No, all the work books have different names, they are each named after a person.

In which case, can we assume there will not be any other workbooks in the folder in question?

I am thinking towards a macro to loop through each excel file in a given folder - don't want to pursue this avenue if there are going to be obvious problems.

There are actually quite a few macros already on this forum which read info from (closed) workbooks in a folder. The quickest way would definitely be an edit of one of these. Search the forum for "each file in a folder" or words to that effect. Also have a look at the results for "reading from a closed workbook".

HTH