Try get all row method.. When one sheet got all data, then set another sheet to get all row. Then Design it further.
Ref