Extracting Data based on user input

Thanks for taking a look.

I'm in k12 education and I have a workbook called TestMaster that automatically collects test data from a bubble reader over the course of a year. Data arrives in sets of roughly 25 unique records which have a consistent test name as a key field. Users need to be able to call up these class sets of records at will for review. We can assume the TestMaster database needs to be sorted by test name prior to processing.

A second workbook called teacher template has a list of all test names available from a drop box and a button tied to a macro to “Get My Tests”

The desired outcome is to be able to have the teacher select a test from the list of test names and then press the button to sort and then extract all the records that match the test requested and place that data on another sheet in the teacher template workbook. My goal is to eliminate as many steps as I can to make this easy for the teacher

The data extracted is then processed in the second workbook providing charts and graphs of student progress but I have that in the bag already.

I've done some programming and have made some cool macros already but I’m a little stumped by this one. How would I best go about extracting the record set from the TestMaster worksheet using the known test name and placing it in a worksheet in the Teacher Template file?