I need to create a filename based on the value in a cell for reference to
another worksheet. Is there any way I can do this with a formula?

='[Manager0"D4".xls]1A'!D4:D22

D4 contains the value I want into the filename and the stuff outside the
brackets is a reference within the ManagerXX.xls document..

If D4=3, the formula should get the referenced cells at the Manager03.xls
worksheet...