Hi,
I have never posted before and am new to Excel macros, so if everyone could bear with me and potentially easy questions, I would greatly appreciate any help you can give.

I am a researcher trying to move a value from a few hundred individual workbooks into one master workbook. The value is in the same location in each workbook and I would like it to be listed in master workbook next to the file name (e.g. A2 would have the file name the file came from and B2 would have the value from that sheet).

Does anyone have any advice on how to do that? If I didn't give enough information, let me know and I can give it.

Thanks in advance.