Using an Excel Ref as a filename link to other data to display

I have a database set up in Excel were I have many excel workbook files (One for each serial numbered item)where I keep track of important information about that item. I also have an overview sheet that lists each serial number in column A followed by important information pulled from the individual workbooks. I have to update each cell by hand to point to every workbook, sheet, and reference cell. There must be a way to use the serial number in column A as a filename reference to the other workbooks so I can just copy each row and update only the serial number cell. Does anyone know how to do this?

Thanks,
Jim