Yes, this is going to be tricky, unless you can train your customer to create separate orders for store-pickup and for drop-ship and for regular-ship.

Otherwise you'll have to create special shipping modules to handle all possible restrictions, as well as back-end support to separate the different order components insomuch as you need to forward appropriate information to your suppliers to do drop-shipping etc.