Hello,
I am a business analyst with an extensive experience on excel tools and systems implementation, including for fashion retailers. So I am very familiar with the data in the sheet your provided.
Here how I see the project :
- I suggest not using VBA, but only formulas that would consolidate the data from the different tabs on the master sheet.
- Whatever the case, you need to have an unique ID common to all tabs. It could be the EAN, or a product code (then we could recreate the SKU code from concatenation of product code and size)
- For it to work, as different people are working on it, we will need to create validation list, to ensure the data people input are standard and consistent (e.g. standardized product categories list).
- It means that for this shared file t wprk, you need both a smart setup for the file, and the right discipline from the different team members (along with someone to coordinate/drive the data input).
I'll be happy to discuss more with you.
Best regards,
Tony