Hello!
I've read your requirements carefully.
Do you need VBA code for the macOS or Windows version of Microsoft Excel (or a cross-platform code)?
In any of these cases, I'll be happy to help you as this task fits my programmer skills.
I'm an expert-level VBA programmer with 15 years of experience, strong at mathematics, have been working with Microsoft Office since version 2000.
I can create the required Excel spreadsheet templates with VBA codes to extract data from different sheets and tables with button options to represent data in dashboards.
My code is high-quality, robust, and well-commented, follows the best programming practices.
Currently, I'm free for this task, will start right after hiring, and complete it in just 2 days.
Let's discuss the details in chat.
Regards.