Redistribute Tables After Import (Dynamically)

[AlvaroSiza]

Background: I am importing tabular data from 5 worksheets into a single worksheet using the following (found here!):

Please Login or Register  to view this content.

I now need to redistribute the imported data in a stairstep manner dynamically. In the attached dummy spreadsheet, Tables 1, 2, and 3 are static and do not require attention. Beginning in Row 66 (4th Table), I need for excel to find the tables title ("Flex Market Statistics") in Column E, look down until finding the string "totals", then cut and paste 15 columns to the right. I then need to repeat this process for each of the remaining tables, always moving 15 columns to the right, but leaving a total of 50 rows for each.

I know this might seem confusing. Please do not hesitate to query me for clarification. I appreciate the help!!

[AlvaroSiza]

Bump No Response

[AlvaroSiza]

Bump No Response.

Mods, can you help me reconstruct my post for better results?