I have some experience with VBA, but mostly editing recorded Macros or modifying other code I've found. This is an overview of what I'm trying to do, but haven't had much success.
Sheet 1 named “Work Sheet”
Sheet 2 named “Data”
Sheet 3 named “Temp”
Sheet 1 has a drop down list of 10 different...