Hi
please can someone help im using google sheets and i want it to search the sheet name based on test A2, then on that sheet find all matching items based on test B2, for example if i choose sheet2 then (a) i want it to search sheet 2 for all matching a's (column A) then output all matching answers to a drop down list if possiable. hope this makes sense, i have added a example link. Thanks

https://docs.google.com/spreadsheets...it?usp=sharing