Link a Master Template Excel file to different excel source files
 

Hello,

I receive different source files that I need to roll up into a master excel
file on a weekly basis. I heard that the Indirect function could help with
this. I haven't tried it yet, do you think this is an option to use or should
I go with any other solution, possibly a macro? Thanks a lot for your help.