Create additional tabs from a sheet's column data

Hi to all.
I would like to be able to create additional sheets by scanning an existing column in my only original worksheet. My existing worksheet contains only three columns with data. Each column has a title. Based on the user's input Excel scans that title's column and creates the additional sheets. The data included in every column contain only 5 or 6 long alphanumeric values. If the cell contains a 5 long value the worksheet created takes as a name the first 2 characters. If the cell contains a 6 character long value the worksheet creates takes as a name the first 3 characters. In case the columns get updated/appended by additional or removed values the function removes or adds sheets based on the user's input.
In the "Test" file I uploaded the user provides as input "Apples". The code goes to the column with the heading "Apples" and creates two new sheets with titles, "12" and "72D", since the first one is based on a 5-long value and the second is based on a 6-long value.
Can someone help me?

Thank you so much.

CheeseSandwich, your code works flawlessly. However, it looks into all columns. I would like the user to control which column gets scanned. So, if the user selects the second column, "Oranges", the worksheets that get created are only 3. These would be, "12", "14", and "42C". If in the future he selects the first column, "Apples", only 2 columns get created, "12" and "72D".

Thank you for the lightning fast reply. Is there anyway to get as input the column's header name and not a specific user defined range?

Thank you so much CheeseSandwich!

Nimrod1313 thank you so much. No more "OK" to delete!