Dear the potential client,
I just take a look at your data, it's big, so I suggest to use VBA excel so I can dynamically change according to your data, any time you input new file.
using formula only makes the file bugging
My name is Hai, I'm an expert in excel template, VBA programming.
Contact me and we can discuss further