User input to select file and save copy in hidden folder

Good Morning Guys.

Before posing my question properly I'd just like to say thanks to everyone on here who's helped me. I've been part of this forum around a year now and had help from here countless times, I've learnt a lot from you guys and I really appreciate it.

I've set up an excel workbook to help me with document control. One of this things I'd like to add to this workbook is a way to select a file and have it save that file under a specific name in a hidden folder. Each document that is created has a worksheet where I keep the details - See attached picture. Step by step this is what I'd like to be able to do.
1. Click a button (to be added to the template)
2. prompt the user to select the document - file
3. prompt the user to select final or native
3. save that file to a hidden folder(final or native) in a set location naming the file using the 'Document Number'_'Current Revision'
4. create a hyperlink to that file in either the document revisions (final) section or the Native Files section

It's really the user input that I'd struggle with, and is it possible to save a file to a hidden folder this way? the files types would be pdf and doc files.

Any help would be fantastic, rep for help as always.

Thanks,

R