VBA and Excel expert for an e-commerce company

We need a VBA and Excel export to help us automate our master assortment generation. Many other jobs will follow if we are happy with what you did. We are an e-commerce company. Our business is built around a catalogue of 7,000+ items. This catalogue is split into 8 categories (called attribute sets). We want to automate the generation of our master assortment based on attribute sets exports. Files have different format and require some reformatting. A VBA macro should do the job. Inputs: - Attribute sets exports - CSV format - Currently 8 attribute sets, but will grow in the future Intermediary steps: - Select attribute set paths - Aggregate all the attribute sets in one sheet - Run various formulas to retrieve some info that is not in the attribute sets Output: - Master assortment (should include selected info only, not the entire content of the attribute sets) - XLS format Other notices: - CSV files include Arabic content. Be careful with the character set