I am looking for syntex that will build a formula.

I want to replace this reference
='[2006 Capacity PMHS Bourbonnais.xls]Capacity Synopsis'!L19

with a formula that will build the reference using data from another part of
the worksheet. It would be something like this CONCATENATE("='[2006 Capacity
PMHS Bourbonnais.xls]Capacity Synopsis'!",F$2,$A9). where F$2 = L and $A9 =
19. Only this doesn't work.