Creating a audit report

[bkpayton]

I AM NEW TO EXCEL AND I AM HAVING TROUBLE WITH A WOOKSHEET I CREATED. ON ONE SHEET I HAVE A DATA PAGE (TABLE) WITH 19 COLUMNS OF DATA. ON SHEET 2 I AM TRYING TO SET UP AN AUDIT PAGE WHERE THE USER CAN HAVE A DROP DOWN MENU OF THE 19 COLUMNS OF DATA FROM SHEET 1 AND BE ABLE TO SELECT WHICH ONE TO POPULATE ON THE PAGE.

---

Example
sheet 1
name Example data 1 Example data 2 Example data 3
John smith 1234 9876 3456
Bill Day 3214 7890 9839
Jane smith 5432 5678 5436



Sheet 2 with drop down menu

Audit report

Name Example data 1 Example data 3
John smith 9876 3456
Bill Day 7890 9839
Jane smith 5678 5436

---

So Example data 1 would be chosen from a drop down menu along with 3. Using Vlookup would take to long because there is 150 to 300 lines of data per column in the actual form.
I would be grateful for any help I could get. Thanks

 

[bkpayton]

Sorry the example of sheet 1 and sheet 2 did not populat correctly on mobile version.