Pasting data from a master file to two other files

My project requires working with 3 different files, in my example here: Delivery Status, Warehouse, and Clients.

Delivery Status is the master file where the information is gathered at first. Then
when the product arrives, from the column "AI" I choose the Destination which it could be a warehouse or client. So far the code that I have can paste the information in different sheets within the File Warehouse, but can not make the difference between the File warehouse and the file Clients.

In the Delivery Status file I can choose from the Column AI whether the destination is a warehouse or a client and I need Excel to paste the information in the proper file. Have in mind that I have a lot of sheets in both files.

I am attaching an example files with the code so far build, and will be happy if you can help me develop it further.

Cheers!