Dynamic Links to closed workbooks on thumb drives

Question

I have a series of workbooks that are stacked in sub folders (below a root folder) on a thumb drive which I want to link data to a master file in the root of the thumb drive.

I would like to have a dynamic link to these files that would update when the thumb drive is moved from computer to computer (drive letter changes from PC to PC). I would like to concatenate the drive letter, subfolder and sheet name into a dynamic link that I could then designate the cell reference which would update as I drag that formula in my master file without needing to manually edit each cell reference.

I have looked at Indirect, Index, vlookup, etc but was unable to figure out how to make it dynamic as the location of the root location changes (root and sub-directories could be copied from the thumb drive to a PC and the path would now be different.

My concatenated path looks like this. C:\Users\gerryp\Documents\proposed\Employee Contracts_Contract Details.xlsx

When I move the directory and sub folders of "Proposed" to the thumb drive the path would change to

E:\proposed\Employee Contracts_Contract Details.xlsx

Within the _Contract Details.xlsx the worksheet that I would want to access would be "Current" and I would want to reference the value in "C2" and then drag it in my master sheet for a number of rows and have the formula increment to "C3", "C4", "C5" etc.

I have the solution for the dynamic links with concatenation as shown below

=IF(F6="","",HYPERLINK(CONCATENATE('READ ME FIRST (INDEX)'!$A$7,"",'Employee Contracts'!$F$4,'Employee Contracts'!F6)))