I have 32 workbooks each containing 24 worksheets. I need to call up data
from the second sheet in each workbook, each of these sheets has a different
name from the others. Is there any way that I can call up the data without
having to give each of the 32 different names, in all cases the worksheet is
the second sheet in each workbook.

Thanks


Dave Glynn