I need help with the "specific" function or creating a Macro, Help Please!!!

Hi,

I have an excel file that I would like to be able to populate information from one sheet to another. I am using a Marco because it will have to use specific words (i.e. "Angel Monroe" technician name). I have multiple field technicians that I am trying to track specific jobs in separate sheets. For example on my master sheet I have a list of each job with multiple columns and different information. One of the columns list the technicians names, this changes per job, I would like to create a sheet for each technician that will auto-populate information from the master sheet when entered. I have attached the Excel file so you can see the Marco I have created. It continues to give me a "compile error: Invalid Outside Procedure". 

I have been told that function "specific" might work but I do not know how to do the correct formula. 

Can someone please help me troubleshoot a resolution to my issues?

Thanks! 

Link to workbook:

https://nam10.safelinks.protection.outlook.com/ap/x-59584e83/?url=https%3A%2F%2F1drv.ms%2Fx%2Fs!Arrb5j7kEY4hkTQvxJsIIk4OvI0J%3Fe%3DchKqUr&data=04%7C01%7Cmegan.gerany%40onegm.com%7C733640d2aa80487c9d3308d9d7998c01%7C1baa7fb59fa5495ca5a26980fd16d311%7C0%7C0%7C637777877522877296%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0&sdata=jHXROKqKDtBnRhYGNFOvlvYPJ3WInGmdNVlZgJvV4U4%3D&reserved=0