Macro Help - Random Select

Hi Guys,

I am looking for a little bit of help with a macro.

I have the following sheets.

Summary
User1
User2
User3

For user1 through user3, these sheets are populated via data connection.

What I need is for a macro to randomly pick an entry from each user1 user2 and user 3, and copy this to summary sheet (only copying specific columns. So if it randomly picks A19, then A19, E19, etc are then copied to summary sheet).

Once this has been done, the following day, the user1/2/3 data will be refreshed, so running the macro again will copy new data to the "next" blank rows in the Summary sheets range.
So Mondays 3 entries will be ranged A2:A5, Tuesday will be A6:A9

Also then need a clear button to be used on friday to then remove all the data ready to start again on the monday

Anyone able to point me in the right direction? (may need more than a single macro )

Thanks

Sorry, Although that helped, it wasnt quite what I was looking for.

I have attached an example of the sheet I am working from.

On the master sheet, I want the macro to look at the RawData_SC sheet.
But when pulling the random information relating to "number" from RawData_SC column A, i want 1 random number for each entry on the "Analysts" sheet.
So from the rawdata, it can see that 25 entries are from Adam and 15 are from Gavin, but I want 1 random for each.

I also need the macro to populate these into columns, so all numbers go into column A, all analyst names go into column B.

So for column B it would need an if statement to look at whatever was listed in column A to be then used as the variable to export the required data to column C/D/E/F etc.

Once this has been done, the next time you press Generate, it runs through again, pulling in new information but adding this to the bottom of the data that is already there.
It cant be exported to Row's as I will be using the row's.

So example data would be:

Result 1 Column A6 (Todays Date), Column B6 (Number), Column C6 (Analyst Name), Column D6 (Company Name).
Result 2 Column B7 (Number), Column C7 (Analyst Name), Column D7 (Company Name).


As the RawData_SC is using a data connection, I cant use a VLOOKUP to pull the information in an array, as once it is refreshed, the previous data is fluhed, which is why I need it to hard copy the data to the new cells.

Hopefully this now makes sense