Couple of issues in the above examples:

1) when the first macro is run, it generated 10,978 rows. But when the second macro is run, it generated 11,110 rows. I feel both of them should have same number of rows. Is there a flaw in these macros ?

2) Macros are unable to generate one continuous excel sheet. Each part of data is separated by a row containing a first cell (such as A1) having the word "Innings by Innings list". The next row again is a blank row with titles appearing (such as player, etc). Can we eliminate rows containing these two words so that all the data will appear in one range ?