Run-time error'9'

Hello all, my company uses the excel spreadsheet for the majority of our companies operational records. I recently ran into a problem using a macro.

1. We have what is called a "lead sheet". On this sheet all potential customers are listed and all the potential outcomes. When a job is sold we change the drop down tab to "sold" like pictured below. Once the person is done entering all of the lead onto this sheet we click the "Run "Lead" to Job-Pebblestone" Macro button. All the jobs that have been denoted as "sold" then get transferred over to our Job sheet for our schedulers and installers to take it from there.

2. When the Macro button is pressed this is what appears. 

3. When the "Debug" button is clicked the image below is what pops up. 

 Can someone please help me correct this issue? It seems like the issue began when I was on the quarantine layoff and the person that was entering this information said they did not have this problem.

Thank you all in advance!!