Pull Data from Multiple Columns Based On Data Validation List Selection

Data validation works fine. Trying to pull data from another tab based upon a selection made within the drop down data validation list. Small test file provided to show challenge.

In advance, THANKS for the guidance!

Fabulous! Works beautifully - Thank you! I used to be really good at pulling data like this but its been a long time and my macro vba writing is rusty. I'll study the example as a refresher and appreciate the guidance!

ATTACHED is an updated version of the file to accommodate 3 rows of data!
Is there a way to replicate the code more efficiently to cover a large number of rows within the column C.
The code you provided works wonderfully and I LOVE IT, but it only works for a single row.
I've taken that code and pasted it a few more times downward and adjusted it to paste in several rows.

The problem is, I anticipate this tracking sheet to track 100-300 rows at a time.
This would require me to paste that code up to 300 times and adjust each chunk to accommodate each row.
I can certainly spend the time to paste it 300 times and update the references, but I'm worried that when the UPDATE button it hit, it might lock up because its going to have to go through a LOT of code to load those 300 rows.

If you think it will be the best route, let me know and I'll proceed with copying it 300 times downward within the code. THANKS!