Reading Table Automatically
There is an Excel file that teaches how to perform the Reading Table Automatically operation.
Excel Solution: Reading Table Automatically
This workbook demonstrates reading table automatically using VBA macros on a 19-row data layout.
Hope it is useful.