Macro to read all tabs at once and Data for each tabs starts from Different rows.

[DataPirate26]

Hi team, 

Is there a possible way to create a macro in which It will read data from all tabs of a single file having different schemas ? But the challenge is in each of the tabs the data starts from different Lines. Can anyone help me with a solution. 

[DataPirate26]

@binuacs Please see the attached Input File which has 3 tabs and the Desired Output. The 3 tabs in the desired output are differentiated by colour codes in the Column A "Client name". 

[DataPirate26]

@binuacs Any Solution to the above query ? 

[binuacs]

@DataPirate26 can you try with the attached macro