Is there a way to create a dynamic link?

For example if I had a list of Workbook names in column A, and a
repective list of links in column B. Is there a way to create one
formula that can be copied in Column B that would dynamically change
according to Column A?

Column A Column B
Legal01 =C:\My Documents\[Legal01.xls]Sheet1!$A$1
Legal02 =C:\My Documents\[Legal02.xls]Sheet1!$A$1
Legal03 =C:\My Documents\[Legal03.xls]Sheet1!$A$1