Excel VBA needed - 2 scripts

Job ID: 31799888

Budget: $10 – $30 USD

Hello. We are looking for someone who could work on it right away. We need 2 scripts.

Script 1.
Combine 7 Files (All have same headers) and perform a few tasks to make the look synchronised.

Script 2.
Data is from 3 different sources, we need to make it look synchronised. For eg. 1 file has Apple Iphone 11, other has iphone 11. So we have to make ALL of them look similar.

Model | Storage | Color | Condition | Price etc.