Link multiple spreadsheets to one central spreadsheet using a macro

A

Amanda

Is it possible to write a macro using visual basic editor
for applications that will search for all files within
one file folder, automatically create canned links to the
same cells within each file and return or update the data
to one central excel file. Each new row would have links
to the same cell numbers but different file names.

Please help!
 
Top