Looking to combine many different workbooks

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.