Concatenate excel cell string within cell reference string

Question

I am struggling to figure out a way to concatenate a cell value into the format below when referencing to another excel spreadsheets cell value.

Example: ='C:\Test\TestA.xls'!$A$25

I would like to have TestA to be represented, for example, by a cell value within the current excel spreadsheet. Here is what I thought would of worked:

='C:\Test\'+B2+'.xls'!$A$25

Is this possible with this type of formatting?

Any suggestions would be appreciated. Thanks

Answer 1

Copied from a Comment by @Dean MacGregor:

You can't refer to another Excel sheet and have it work unless that other Excel sheet is open.