Needing guidance on how to proceed with workbook ( gonna be a doosie)

[rlink_23]

So to start I build a "sales sheet" some years back that when info is entered in it transfers the data to the "register", and pretty much works great. It hyperlinks the "quote number" so when you click it it takes you to the original quote in the save folder.
So in the office we have people who enjoy stealing sales, so I am building a new sheet that everybody will use and basically locks in the quote (don't have access which would be much better for this) but it has an userform that info is filled in and then transfers to the "quote sheet". But I want to incorporate the sales sheet and not being super familiar with Userforms I dont know if I am able to hyperlink the "quote number" to the sales sheet and transfers all pertinent data to the proper cell on sales sheet, (adding sales sheet to the new workbook) or if I should have a textbox that you enter the "quote number" and have a command button that user will click and it transfers data to specific cells based on the quote number. I have stated any vba on this yet, just asking advice on how you would proceed. And then maybe help with the coding after haha... have a wonderful day and thank you all so much for your kind help!!