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!