Hmh... your code makes sense. Here's just one challenge...

In my example, I just "Alpha", "Bravo", etc. to simplify the scenario/problem. In my actual data, however, my categories name are longer. For instance, "Bravo" is actually "PREVENTATIVE ACTIONS (TYCOM or CMD Specific)". While this works fine with identifying the columns, the length of this string won't allow me to use them as worksheet names. For instance, the line of code "With Sheets("ConvertedData_" & myCategory)" would result in the tab name being chopped off.

So, is there a way to NOT make these dynamic and simply call the function? Generally, I like the "dynamic" approach but in this case, it would throw an issue.