I have gone through your requirements. I can do it easily, as I have done it before many times..
I can do every possibility in Excel and VBA, Google Sheets and Google App scripts. I have 8+ year experience in Excel, VBA, Google Sheets and Google App Script...
Plz share your requirements, I will surely help you on the same...
I m new a freelancer, looking for good ratings and reviews, So you will not be disappointed at all..