Hi
It is quite difficult to imagine what specific difficulties you encountered while building such a scenario without sample data and/or screenshots of what exactly is happening but I believe implementing pagination logic using “Repeater”, “Set variable” and “Get variable” modules might solve it.
I would recommend checking this topic that explains pagination basics which (slightly amended) you could implement into your scenario.
Pagination routine/logic works miracles
Cheerio