I have a series of 15 spreadsheets, all having the same column
structure.  They all have the same filename barring first two letters
which refer to a persons initials.  The 15 files are stored in the
same directory.  In that directory I'd like to create a sixteenth file
which consolidates much of the data in the 15 files.  I want to use
that consolidated data in a pivot table.  I know that the top-left-
hand-corner of the range I want within each of the 15 spreadsheet
files is the Cell A10.  I cannot be so precise with the bottom right
hand corner (BRHC) as the number of rows is variable in each of the
fifteen sheets.  I know that the BRHC is in column S (if that
helps).   Additionally, within each of the 15 files there is around 25
rows of data below the BRHC which I do not want to insert into the
consolidated file.

Can anyone give me pointers as to the easiest way that I can create
the sixteenth file, without having any blank rows in that consolidated
file.

Ideally without the hassle of having to open the 15 files.

Thanks.