I am proficient with excel macro/VBA development, I can write the macro to update worksheet dynamically as specified, if you are interested feel free to message me, I am available to start your project immediately, looking forward to chat further and work on your project