Multiple Worksheets

[Jim]

Would like to import a specific cell range from multiple
sheets into access (Would eventually run over several
different excel files). Although the cell range is the
same on each sheet, the number of sheets in excel file
will vary and the sheet names will not be the same.
Tried nameing the range using 3D and access spreadsheet
tranfer only brings in the named sheets, not all sheets in
the file.

Thanks for any help,

Jim
..