Reading Sheets Automatically
There is an Excel file that teaches how to perform the Reading Sheets Automatically operation.
Excel Dashboard for Reading Sheets Automatically
This workbook demonstrates reading sheets automatically using VBA macros on a 42-row data layout.
Hope it is useful.