Use VBA to Autofill a Sheet by Selecting an Entry

Hello! I am not even sure how to best word this question, but I will do my best. I have a sheet with an entry form where users input data and this data is saved on a separate sheet in the same workbook. I want to create something that will allow users to see a list of previous entries (by name or account number) that will allow them to select a certain one that - when selected - will autofill a sheet with all the data from that one entry. I assume this is possible, but I am not sure where to start. Please let me know if you need more clarification and I thank everyone helping in advance!

Sure! If you go to the third sheet (CAP), you will see all the fields for a complete entry. On the first sheet (Entry Form), I want to add a button that users can press that will auto fill fields for a complete entry on the sheet called 'Record' that the user will then be able to print out. Does that make sense? My workbook is attached.

Hi! Just checking this to see if anyone has any suggestions. Thanks!

OK. I will add that and re-upload my sheet. Thanks.

If you click on the 'Click Here to Add Corrective Action Plan Information' button on the Entry Form sheet, it will pull up my Entry Form. I added a 'Fill Record Sheet' button that I would like to populate the fields on the Record sheet once a user makes a selection using the 'Find by CAP Name/Reference Number' box and then clicks the 'Fill Record Sheet' button. Does that make sense? The new workbook is attached. Please let me know if you need more information.

Thank you! Works great!