Link question

I have been asked to create a 'main view' excel file which automatically updates if changes are made to a file linked to it, which is fine. But it is the enomity of the task which is freaking me out! There will be 25 files feeding into the 'master view', each file will have 40 rows and 30 columns of cells in it. Do I reallt have to manually configure 43,000 individual links or is there a quicker way?

All help gratefullu received!

Thanks Sweep, if you ever need a kidney!