Msgbox Macro For Automated Vlookup

I am writing a macro for people at work to use to automatically vlook-up data from another spreadsheet.

I wanted to base it along the use of a msgbox as they are not the most tech-savy people.

I want the msgbox dialogue to go something like this -

Which spreadsheet do you want to pull in data from?

The user browses to the file they want

Which columns do you want to transfer?

The user types in the columns

Which columns do you want them pasted to (in new sheet)?

The user types in the columns they want to paste to
and then macro does the vlook-up.