Need macro help sign in sheets

[air23live]

I need sign in sheets to populate based off of a master list.

I need them to populate based off of what crew they are assigned to.

For example I need a sign in sheet for all of the people on John Doe's crew to be on one sign in sheet
and Jane Doe's crew to be on one sign in sheet etc.


When i update the list add or remove EE from master list I need the sign ins to be updated automatically.

I have attached dummy file

Thank you so much!

 

[air23live]

I don't see an option to add attachment ; (