Clean up VBA code in Scheduling Tool

I would like you to 1) clean up the code to provide the same functionality, but faster, 2) allow the user to select rows in the "bucket dates" tab so that they transfer to the correct worksheets without requiring them to copy and paste the sales order numbers to column A of each sheet. These sales orders drop off the list as soon as the order is fulfilled, or in other words, when the sales order no longer exists on the OORPT tab. The sales order data must always come from the OORPT tab, and not the bucket dates tab. 3) Any orders in the 4 main tabs that are past due show up at the top of the list and are highlighted yellow, 4) On the Wty Limbs tab, there is a Group Column at the far right (column Y). If Column X (Cust PO) contains "RA", RA1 must appear in column Y and increment up each time, in other words, if rows 3,4,5 contain RA in column X, Cell Y3, Y4, Y5, should say RA1, RA2, RA3, respectively. If the words "Prevail" or "ProForce" appear in the Special Inst Column (Col W), then the Goup Column cells should say T1, T2, T3, when they are scheduled. Any cell in the Group Column that is left blank must contain a unique letter each day, so A, B, C, D, etc..