Excel VBA: random data based on specific range

Hello experts,

I have attached a formula which allows me to random values from specific range. (I.e: Formula sheet)

I would like to take it as a reference to cover the following requirement:

1-InputBox: "Select the range in which is located your reference data."
2-Inputbox:  "Select the column in which you want to random the data"
3-Inputbox: "Report the last row in which you want to random values example: 16."
4-Random values as reported in formula sheet.

Reference data and column in which will be reported random values can be either in the same sheet or not.

If you have questions, please contact me.

Thank you for your help.
Dummy-file-random-data.xlsx