Collate Unique Cells From Many Workbooks

I have approx 850 workbooks with different names. In each workbook there are unique cells that I need to collate into rows in another separate workbook. For example:

Workbook named ABC123 - on the sheet named �cover sheet� I need to record the information from cell�s A1, C3, D3, C37 and D37. Into another workbook called record book. I need each row in the record book to unique to the individual workbooks. For example information from ABC123 will be recorded in row 2 of the record book while information from ABC456 will be recorded on row 3 and so forth.

I have been opening each book and copying and pasting each cell (my fingers are killing me) into the record book. Just thought somebody may know another way. Not familiar with vba or even how to insert it into excel.