Indirect concatenate formula

[nldstorm]

Looking for some help with an indirect formula linking different cells and pulling information out of a different worksheet stored on the network. I have workbook with following cell contents:

Cell A1: B (REPRESENTS XXX IN THE FORMULA BELOW)
Cell A2: 9 R(REPRESENTS XXX IN THE FORMULA BELOW)
Cell A3:BPC Tools (REPRESENTS YYY IN THE FORMULA BELOW)
Cell A4:='G:\__Business Finance Shoes\08 Forecast Models\z. Shoes\Global Model\YYY\Fixed Cost\[CIW Fixed Cost Check.xls]BI Query'!XXX

In cell A5 I want to insert a formula using INDIRECT and CONCATENATE so that it pulls the info from cell B9 (XXX in formula), BPC TOOLS (YYY in formula) using the path listed in cell A4.

Cells A1, A2 and A3 will be volitile.

Any suggestions?

Thank you

 

[Special-K99]

Try

in A4
="'G:\__Business Finance Shoes\08 Forecast Models\z. Shoes\Global Model\"&A3&"\Fixed Cost\[CIW Fixed Cost Check.xls]BI Query'!"&A1&A2"
in A5
=INDIRECT(A4)