Hi,
I have more than 50 excel files in folder and sub folders,I need to hyperlink files based on partial file name that I enter in sheet 1 of my Master file and copy sheet 2 data from all those files into my Master file sheet 2.
Sample file attached for reference.