I have a spreadsheet which is basically a source of different file
contents.
In
Column A I have the file name (C4835)
Column B I have the variable path which is always the first three
characters of the file name (C48)
In another row I would like to do a link to show what appears in A1
(title) of each sheet.

I have 2000+ lines so would like to automate in some way the changing
of variable part of the file path and file name in each cell.

Examples
'\\company.local\Server\Office\Cpacks\C48\[C4835.xls]Short'!$A$1

'\\company.local\Server\Office\Cpacks\C51\[C5185.xls]Short'!$A$1

Any ideas please ???




--
PSM