I wouldn't do any of this. Use a Power Query (Data tab) to scan the sharepoint folder. Find the workbook based on some logic. Load Query to sheet. Now you have the name of the workbook which can be dynamically used in formulae.