[Solved] CONCATENATE to build ext reference using cell range

Hi People.
Im trying to build a path to an external files cell contents for each row in the attached file, depending on the Agent number. So the formula will take the Agent number for the cell and build it into the path name and the filename. This way as Agent files are created, teh overview file will have the scores stored already.
All of the external files fall into the same naming convention and location based on Agent numbers:
e.g. All filenames are [Department][Agent number][file format] ("QA Agent 7007.ods") - QA/Voice/Agent 7007/QA Agent 7007.ods.....so as you can see its just the Agent number which needs to built into the external reference.
Should I use CONCATENATE?
Formula in Sheet "Results Voice" cell D8 (currently only the direct reference)
Agent name in cell B8
Path in Sheet "Menus" cell F3
Naming convention in Sheet "Menus" cell G3
Im imagining something like:
=file:///W:/QA/Call Quality/Agents results/Agent(CONCATENATE(B8;".ods'#$Calls Sheet 1.O42";))
.....hopefully resulting in
='file:///W:/QA/Call Quality/Agents results/Agent 7001/Quality Agent 7001.ods'#$'Calls Sheet 1'.O42
Any help is very much appreciated Gents
Cheers.
P
Im trying to build a path to an external files cell contents for each row in the attached file, depending on the Agent number. So the formula will take the Agent number for the cell and build it into the path name and the filename. This way as Agent files are created, teh overview file will have the scores stored already.
All of the external files fall into the same naming convention and location based on Agent numbers:
e.g. All filenames are [Department][Agent number][file format] ("QA Agent 7007.ods") - QA/Voice/Agent 7007/QA Agent 7007.ods.....so as you can see its just the Agent number which needs to built into the external reference.
Should I use CONCATENATE?
Formula in Sheet "Results Voice" cell D8 (currently only the direct reference)
Agent name in cell B8
Path in Sheet "Menus" cell F3
Naming convention in Sheet "Menus" cell G3
Im imagining something like:
=file:///W:/QA/Call Quality/Agents results/Agent(CONCATENATE(B8;".ods'#$Calls Sheet 1.O42";))
.....hopefully resulting in
='file:///W:/QA/Call Quality/Agents results/Agent 7001/Quality Agent 7001.ods'#$'Calls Sheet 1'.O42
Any help is very much appreciated Gents
Cheers.
P