Macro to create multiple sheet, copy certain values and loop until end of row data

Okay. What if I need to select the following range C:14 to E14?! They are three cells, adjacent cells I need to auto-populate, to the right of B14 from which the name of the worksheet, created by macro, is derived. Thanks again, Rory.