check out the indirect() function
if the worksheets are listed in row 1
and the workbooks are listed in columnA
=indirect(A2&B1&"B2)
would get you the data from workbook A2 and Worksheet B1 cell B2
Note that you will have to set the format for the cells properly.

"Ginger" wrote:

Hi,

I was wondering whether it was possible to use a file name generated by a
formula or, collection of formulae, as reference to an external spreadsheet.

For example, if I have a different sheet for each month of data within a
different spreadsheet file for each year is it possible to fill in the
constituent parts of the file name and sheet name to get the correct data? I
am hoping to be able to to this from column and row headings ideally.

Many thanks in advance!