Search and fill the cell with certain content found in a different worksheet tab

Hello mathetes ,

Do you have cases where the same customer appears multiple times on one or both of those two spreadsheets?   Yes

How many rows of data are you getting from PayPal? Around 1000

I can see paypal file have a transaction ID column. Transaction ID can be found also on my exported transactions file together with client address. The problem comes with other payment methods like card payment and bitpay payments, for this cases I have adddress, city, and state but its missing Country. ON this 2 payment types Bitpay and credit card I can only use email as search criteria. Maybe we can use both search criteria (email and transaction number) , if any of this is found , then copy content from address cell (or country cell for bitpay and credicard) to another respective cell from other worksheet tab with the same client. If we only use email search will not work because some paypal clients are using different account emails on their paypal.

I shared sample excel where red text column must be filled with client info from the 4th worksheet tab https://1drv.ms/x/s!AoCBrgsOy4dw0RXvWvcK3CbDmkga?e=tPNjVL

If posssible... :

1. I also need some help to remove time from date column on credit card tab, for instance first cell has 6/5/2018 14:54
content ,while I only need 6/5/2018.

2. I also need to automatically generate a contract for all clients using their respective name and full address extracted from the resulted excel. Each client must have a single contract with the date of the contract to match the order date found for that user first dated order found in excel (the oldest payment date for that client). The contract will be the same for all users (same service description), only the name , client address and contract nr/date will be different. All this contracts name and numbers ideally must be generated and a 'contracts' folder and listed on a excel column and I can simply select the column and I can print them all .  https://1drv.ms/w/s!AoCBrgsOy4dw0RbYCTV8etiwzjFv?e=XRlIli (can be in excel)

3. I need to generate invoices for each excel line as that is a paid order. Each invoice must have a default text with what I did to the customer(same exact text for all clients) + contract number and date token from point 2. Each client must have a single contract number/date on all invoices - the one generated point 2. The invoices can be stored in a invoices folder and be accessed on an excel invoice column created on the first shared example excel ( invoices and contract number can start from 1).   https://mega.nz/file/ToIQGIxC#QrFrqA3HoAyyu-xOriNfCVr9cT6MJ3mQ9bWEVJINXKQ where red text must be filled with correct data.

Thank you !