How to select random Number from a list and populate another sheet

[Lensmeister]

Hi all,

Thought I'd ask if something was possible in a general sense first before getting in to specific details.

I will have a list of numbers in Column A on Sheet 1 along the lines if 1251. 1252, 1555, 4596 (All four digits) one 4 digit number per line. These are fixed numbers and the only ones that can be used.

On Sheet 2 I will have Columns

Column A called Date
Column B called H1
Column C called H2

So now comes the hard question:

What I need to have is something to populate Sheet 2 cell B2 with a number randomly taken from Sheet 1 then repeat for cell C2.
Then repeat this for cell B3, C4, etc down to say line 200.

How on earth do I do this ?

Hope this makes sense.

I have not got a spreadsheet put together yet that I can show.

Thanks in advance,