I have this application with files (1 - 60 excel files)
that gets populated every month with data from +/- 50-60
various sources. Every month however, I have to copy,
rename, re-link the new worksheet to those 50-60 sources
manually, since the data changes every month. Can someone
assist me to write a macro or code that would re-link
these files with one push of button via a common dialog
type pop-up pointing to the file location to be linked to
via a looping method?