I have a sheet that is used to track excel sheets on our sharepoint.

As an example i have included example link ='http://intranet/commercial/Product Vault/[FG040164.xls]'!$C$11

My question is, is there a way to substitute [FG040164.xls] with a value that is kept in column A, so that i can autofill all future links

ie

FG123456 ='http://intranet/commercial/Product Vault/[FG123456.xls]'!$C$11

thanks in advance