You guys are always awesome with insight into difficult excel situations so I have another one for you. I have a convoluted way that I need to lookup the value in an external macro-enabled workbook. I need to concatenate the workbook network address, a dynamically updating cell that is the sheet name, and the same cell in which data exists on each of the sheets. I can handle the concatenating function, but I can't seem to find the correct indexing or lookup function/protocol that returns the value of the concatenated string. I can't use the indirect function for looking up values in the reference workbook because the workbook has hidden sheets. If this needs to be done via VBA, I will redirect my question there. Example workbook attached.