Can auto flow text be set up so that the right hand column is filled first then the left hand column
I have 44,000 numbered membership cards to be 10up on A4 (4,400 pages)
Try manually creating text frames on the master page, then thread them in the order you want the text to flow.
But this sounds more like a Data Merge project, which doesn't use your guides or frames. Why does it need to fill in that order? I presume these will eventually be cut apart.