Looking to combine many different workbooks

[RA2925]

Hi,
Okay so I have about more than 50 different workbooks with no specified naming convention (i.e Workbook1, bookwork122, example3) and I would like to create a Master Workbook that displays all the information from the other workbooks. In the master workbook, the first column should contain a certain cell from each workbook (same cell in all workbooks), the second column should contain a certain cell from each workbook (same cell in all workbooks).. and so on so forth. I have no idea how to write a Macro for this. Any help would be GREATLY appreciated.


Thanks in advance.

[AlphaFrog]

Here is example code that you could modify to suit.

Merge data from all workbooks in a folder

[RA2925]

Woah! You are awesome!!!!! Thank you so muchh!!!!!!!!! Truly grateful!

[RA2925]

Is there a way that it could possibly update automatically, or every time i re-open it? Like if I make a change in one file i would like for it to update.