I need to develop macro for selected but varied data

Job ID: 35939077

Budget: ₹600 – ₹1,500 INR

It requires VBA code knowledge to develop modules to eliminate repeative work and automate the task as per different Excel sheet data.
I've almost designed the task framework just need modification with codes.
Project minimise the routine task to arrange data to prepare measurement description as per standard. Basically it deals with concatenate, Column filter. Almost 70% completed but struggling with some modules.
I've attached the files I've been working on. Title with project 1 has written with VBA modules on which we have to work for two different data Excel sheets.