How can I shuffle multiple independent data list with Excel VBA

Good afternoon!

I have multiple data set (numeric) in the same number of rows (data set per row). Those data set have equal size.
I'd like to rearrange randomly and independently the values in my different lines (=keeping the values if a same set on its original row but changing its column). I would like to keep shuffling the different lines until the sum value of each column meet some conditions. I'm used to code simple loops in VBA, but I'm blocked with my shuffling problem. Here is an example of datasets I'd like to shuffle: Example of datasets

I hope I could describe clearly what I'm trying to do.

Thank you in advance.