automatic link updates

HI!

Ok I'm creating a master list. I have employees filling out a survey form in excel and sending it back with specific file names. i.e, 14P039 SURVEY.xls


Now- my spreadsheet extends to column BP, and row 1200, so its pretty big, however, I'm hoping to be able to have it automatically update.

Is it possible to save all the surveys, into one folder, and create external links to them.

Each cell on my master is going to link to a different cell on the survey.
Is there a quick and easy way to do this?

Please see the attached example

Thanks so much !!