I am trying to automate work timesheets by using a spreadsheet that
references two different spreadsheets that list job numbers, names and task
numbers.

I currently have the spreadsheet set up to import and update the two
spreadsheets containing job info.

I also have the time sheet set up so that when a user types in the job
number, the job name automatically appears in the proper location.

I need to some how get the spreadsheet to look up the entered job number and
return a dropdown list of available task numbers related to that specific
job. Task numbers and quantities of task numbers vary per job.