So I have a searchable drop down list I have created to reference a huge data list on another sheet, I have started sorting this data into other sheets based on "Technology" HID, CFL, FLUORESCENT T5 as a few samples. Does any one have any suggestions on how to make the first drop down in A1 be a reference to the drop down in B2 to pull the data from the specified table with that technology?

thanks for any help and please let me know if I can clarify anything.