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