Finding Table Automatically
There is an Excel file that teaches how to perform the Finding Table Automatically operation.
Excel Professional Finding Table Automatically
This workbook demonstrates finding table automatically using VBA macros on a 89-row data layout.
Hope it is useful.