How to integrate all VBA code in an optimized way and exist to ThisWorkbook?

Hi,

I added the VBA code for each worksheet to allow multiple selections in a drop-down List, but it runs slowly and lags. Thus,

How to integrate all VBA code in an optimized way from each worksheet and exist to ThisWorkbook, and keep its basic function unchanged?

How to update to code to sort the selections according to the order of the drop-down menu in the cells?

How update the code to available to delete a part of selections (such as remove unwanted options) in a cell?

Example 1:

Example 2:

This is the file as reference:

Many thanks

1.png (12.9 KiB)

2.png (13.3 KiB)

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

question