Create new worksheets with names based on dropdown values

I've got a macro that autofilters my main sheet based on data entered into dropdowns (names) and checkboxes, and then creates new worksheets based on those criteria. (We're creating separate work orders for individual contractors who are named in the dropdowns.) It was working great until I was asked to make the sheets' names reflect the names selected in the dropdown menus, rather than their numerical values, and when I tried to implement that, it stopped working. Here's what I've got:

Please Login or Register  to view this content.

Previously, I was just naming the new sheets like so:

Please Login or Register  to view this content.

Like I said, that was working great, but unfortunately the folks who tasked me with this project want the actual names on the sheets.

I sort of understand why my current code isn't working, but can't quite work out how to get it running correctly.

Working perfectly, thank you so much!