As you're using v8 Pro, you can open an Excel file as the primary data source (instead of the common text report file). Then you can build external lookups to bring in data from other Excel files.
When you save this model, the file names and locations will be stored within the model.
Finally, you can build project exports to assist in export tasks which will be routinely generated. Defined project exports will be saved in your model as well.