Split Array into an Unknown Number of Separate Arrays

I have a list of names in column A on sheet 1.
Upon running a sub, those names are placed into an array, shuffled into a random order and then put back into sheet 1 column a in their new order.
What I now want to do is evenly split the array values by a number that the user enters via an input box and for these to be placed in their own array.

i.e. If I have a have a list of 100 names and the user enters 4 after being prompted, 4 different arrays would be created with 25 elements in each.
Similarly, if the user inputs 5 then 5 different arrays are created with 20 elements in each.

I do not mind in terms of naming conventions for the arrays. I guess something like arr1, arr2, etc would be easiest but I just can't figure out how to do this!

Any help would greatly be appreciated.

Here is my code so far:

Please Login or Register  to view this content.

Thank you for the response but unfortunately I need to do this without manipulating data on the worksheet.
At the moment I am putting the randomly sorted array values back on the worksheet but this is just for testing purposes.
Eventually (hopefully) all the manipulation will be done is the memory.
I need the x number of different arrays as each of them will be used to populate an email body.

Thank you all for you help.
Ideally I do not want to manipulate or change the data on the worksheet in anyway - I want it all to take place in the memory.
This is because there are vast amounts of data in the worksheet (I have simplified my question to make the concept easier to understand).
I could split the array across multiple columns in a new worksheet, collect the data I need and then delete the worksheet but ideally I don't want to do this.
I suppose I could use a 2d array and then I could just reference a specific column within that array.

Can anyone advise me on how I go about setting the number of columns in the array dynamically (based on a user input) and then split the values across each of the array columns evenly?

Once again, thanks everyone for their help so far.