Copying data from Multiple spreadsheet to single spreadsheet

As the title suggest, I am trying to copy data from Multiple spreadsheet to single spreadsheet. There will be around 200-300 sheets. I did a lot of googling and found the following macro to be best.


But the issue is I have some sheets, where first column is blank for all the records.

For example I have 3 sheets like these.

1	AAA
2	BBB
3	CCC
4	DDD

5	EEE
	FFF
	GGG
	HHH

9	III
10	JJJ

When I execute the macro it is creating a final sheet like this.

1	AAA
2	BBB
3	CCC
4	DDD
5	EEE
9	III
10	JJJ

It is not copying the FFF,GGG and HHH rows. From further analysis I found that, when the macro is looking for the last cell to start pasting data for the next spreadsheet, It pointing to

FFF

Thus it is overwriting F,G and H records.

How to overcome this issue?